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 ('2071810')
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 ('2071810')
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.
N4324UPerot Mark E · Homer, LAN4326ULampley Timothy · Nolensville, TNN4327UHodges Caleb F · Omaha, TXN4329UCarvalho Brandon A · Camarillo, CAN432DTrollinger Lari D · Wanette, OKN4330UPalmer Dana G · Gatesville, TXN4334UTusko Air LLC · Choctaw, OKN4335UHarrison Wesley V · Kemah, TXN4337UStroope Jerry S · Pearland, TXN4340UBenford Kenneth R · Haleyville, ALN4343UBurke Jonathan D · Gaylord, MIN4344UKelly John M · Gastonia, NCN4345UCaskey Martin K · Paso Robles, CAN4347UAland Raymond J · Saint Clairsville, OHN4349UEmbry Riddle Aeronautical University · Prescott, AZN4358UThomas Reginal D · Apison, TNN4366UScott Michael D · Chippewa Falls, WIN4370UNeal Gordon T · Massillon, OHN4371UBarnett Gina L · Columbus, TXN4378UWissenbach Richard G · Pinesdale, MTN4384UMarkey William C · Wenatchee, WAFirst renewal noticeN4387UR&M Steel Co Inc · Caldwell, IDN4393URoberts Alan W · Emmetsburg, IAN4394URawdon Robert C Jr · Hohenwald, TNN4395UMhaskar Advait S · Burlington, IAN4396UMetz Daniel J · Brighton, CON4400UMax Power Aircraft LLC · Kenosha, WIN4413USpears David A · Naperville, ILN4417UBlacqjacq Aviation Co · Wilmington, DEN441SSSchwarz Mickey D · Thorndale, TXN4423UReed Andrew · Peck, MIN4425UAlbers Brian C · Portland, INN4427UEichmann Sheri L · Paulden, AZN4428UAtlanta Sky Signs LLC · Sharpsburg, GAN4430ULfm Aviation LLC · Bozeman, MTN4432UHull Ronald W · Temecula, CAN4442UBas Part Sales LLC · Greeley, CON4443UFratangelo Robert A · Sodus, NYN4447UTrenter Ray J · Waynesboro, GAN4450UGrove Keven W · Ankeny, IAN4452UDiehl Annette L · Pasco, WAN4453URedcardinalaviation LLC · Chantilly, VAN4460URegistration Pending · Lake Saint Louis, MORegistration pending, canceledN4461ULeroux Phillip E · Dallas, TXN4463UAinley Timothy R · Naylor, MON4467QDenman Richard E · Rough And Ready, CAN4470UBlack Kevin J · Edgewater, FLN4471UCameron Schoessler Aviation LLC · Bliss, IDN4473UChickasha Wings Inc · Chickasha, OKN4476UTowne Sheldon E · Whitefield, NH
Back to Cessna 150D