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 ('2072730')
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 ('2072730')
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.
N92464Tuschka Ted H · Donnelly, IDN92466Pierce Bradley D · Waco, TXN92467Jacobsen Thomas R · Auburn, CAN92472Boyle Neal · Beaver Island, MIN92479Hill Top Aviation LLC · Humboldt, SDN92481Barraza Construction LLC · Saint Joseph, LAN92486Big E LLC · Lemoore, CAN92492Meger Daniel F · Lincolnton, NCN92495Welborn Mark Grant · Boonville, NCN92519Flory Air LLC · Culdesac, IDN92520Heartland Air Services LLC · Wilmington, DEN9252GEmbry Aero Ltd · Greenville, ILN92532Jones Timothy D · Cooper, TXN92534Courtney Joseph D · Livingston, LAN9253GSteiner Ivy C · Fairhope, ALN92541Larson Alexis Kae · Bismarck, NDN92542Timing Building LLC · Wilmington, DEN92546Maracek Thomas · Middletown, CAN9254GStowe Henry L · Covington, GAN92551Brazos Valley Flyers LLC · College Station, TXN92554Kortsen & Associates LLC · Flagstaff, AZN92557Soto Naomi · Ocala, FLN92559Olmo William J · Priest Lake, IDN92567Registration Pending · Orlando, FLRegistration pendingN92584Buckner Walter · Columbia, TNN9258GHerb Meloche Ltd · West Allis, WIN92597Morgan Ent LLC · Richland, IAN925RRHahn John K · Evansville, INN92600Windh Steven R · Reedley, CAN9260GPeyton Julia H · Santa Barbara, CAFirst renewal noticeN92616Holby W Barrett Jr · Warren, RIN92638Van Raden Chris · Portland, ORN92639Pryor Aviation LLC · Hutchinson, KSN9263GN9263g LLC · Marshall, MON92644Atkins Doug · Murfreesboro, TNN92648Bender Phillip H · Bloomingdale, OHN92665Rupke Curtis · Washington, NCN9266GCole Mark A · Forest City, NCN92675Miller Saima A · Kodiak, AKN92677Burriss James E · Piedmont, SCN9267GWaypoint Financial Services LLC · Raiford, FLN92680E & T Research And Development LLC · Sanford, NCN92690Nelson Richard B · San Mateo, FLN92691Registration Pending · Lebanon, TNRegistration pendingN92707Farquharson John L · Goldsby, OKN9270GFrye Warren S · Galax, VAN92712Pfister Michael J · Roanoke, ILN92725Tucker Kyler T · Cypress, TXN92726Gray Stanley Paul Jr · Temecula, CAN9272GSena James H · Edmond, OK
Back to Cessna 182N