Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2072710')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2072710')
ORDER BY n_numberRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N9079XWessel Eric B · Peabody, KSN9081XKardack Michael R · Lopez Island, WAN9083XAhl Of Montana LLC · Lolo, MTN9084XWareh Nabil · Corona, CAN9085XCessna 182 LLC · Missoula, MTN9087XLane James T · Theodosia, MON9088XFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVN9089XSebec Aviation Services LLC · Willimantic, MEN9092XWharton Joel E · Millsboro, DEN9095XTaylor William E Trustee · Waynesville, MON9097XMcmillin Charles R · Lynn, MIN9098X98x LLC · Caddo Mills, TXN9099XSnow Sam L · Las Cruces, NMN9101XMadsen Travis E · New Underwood, SDN9102XReynolds David Keith · Bastrop, LAN9103XBeechit LLC · Prescott, AZN9104XWoods William M · Ochelata, OKN9106XCollinsville Design LLC · Newington, CTN9108XDighans Michael J · Peerless, MTN9109XUplift Aviation LLC · Dover, DEN9110XCoffman Ryan S · Marysville, WAN9112XSorenson Chad · Soldotna, AKN9114XDk1 Aviation LLC · Fayetteville, NCN9116XTaylor Aviation Inc · Fort Benton, MTN9120XStevens Matthew J · Onaway, MIN9122XBissell Lee G · Culver, ORN9126XStrandberg Sigvald J Jr · Nome, AKN9134XDardas Thomas M · West Peterborough, NHN9135XTingley Thomas A · Groveland, CAFirst renewal noticeN9138XVictor Valley College · Victorville, CAN9141XFowler-Carpenter Shirley · San Antonio, TXN9144XWinsome Ag Services LLC · Johnson, KSN9146XMangun Charles L · Middleton, IDN9158XSutton Randall D · Rexburg, IDN9165XShults Jerry G · Kingsland, TXN9167XRichard I French · Eatonville, WAN9169XAllen Air LLC · Fennville, MIN9172XRegistered aircraftN9177XCleary Brothers LLC · Tompkinsville, KYN9923TPrevo Jerry L · Anchorage, AKN9924TBlue Skies Aviation LLC · Wall, SDN9927THauser Thomas R · Johnson, KSN9930TWateractive43 LLC · Auburn, CAN9931THanft Douglas N · Raymond, CAN9933TOrr Kory A · Hay Springs, NEN9938TShope Brandon M · North Pole, AKFirst renewal noticeN9946TKruger Matthew J · Pine Island, MNN9948TMoulton Robert J · Filer, IDN9954TWoodford Douglas P · Colbert, WAN9955TWheeler Aaron T · Columbia, TN
Back to Cessna 182D