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 ('2072714')
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 ('2072714')
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.
N3624UWilkinson Larry G · Henderson, NVN3627UStribling Tyron S · Lagrange, GAN3631UBurden Richard M · Woodway, TXN3633UBrasher Cecil V Jr · Jamestown, NCN3636UVandeman Jack P · Norco, CAN3639UWaltz Elizabeth · Grapevine, TXN3640UMarkle Raymond J · Madawaska, MEN3642UPm Barrett Aviation LLC · Tucson, AZN3643UN3643u Aviation LLC · Denver, CON3644ULawrence Carl E · Boulder, CON3645UHusaim John Steven · Hohenwald, TNN3646UGarner Lynn · Preston, IDN3647UAdams Verne Franklin · Madera, CAN3648UMerlin Aviation LLC · Grants Pass, ORN3649USteele Aerospace Service LLC · Tulsa, OKN3651UDeibel Adam · Flagstaff, AZN3653UMedeiros Germano Manuel · Caruthers, CAN3655UBoggs Dennis E · Buffalo, WYN3656UMccarty Troy Allen · New Plymouth, IDN369KSkydive Inc · Eagle Creek, ORN411KMRowe Kieth C · Big Bear Lake, CAN433LLSkydive Coolidge Inc · Tempe, AZN465CTMatter Terrence K · Reno, NVN566JWRoss Stephen D · Greenfield, OHN5706RGraham Charles Arbe · Dexter, MIN5715RBingham David · Marked Tree, ARN5820RBlack Jan P · Yucaipa, CAN615FUN615fu LLC · Nashville, TNN616WERodriguez Norberto R · Inwood, NYN629WCCollins Jeffery Scott · Griffin, GAN6611XNelson Ann · Box Elder, SDN6700TKimmerle David · Blanding, UTN68AChase William R · Santa Fe, NMN694QPhillips Todd · New Albany, MSN75SMSummit Aviation Adventures LLC · Fairplay, CON771EEBtr Inc · Chula Vista, CAN79GSUavionix Corp · Bigfork, MTN81HDSkytte Christian · Wichita, KSN830WDurakovich David A · Coshocton, OHN835MDMacconnell John · Deland, FLN983AWGuthrie Robert Paul · Joiner, ARN999TKPearson John L · Stevensville, MTN9LGCalfee Ray I · Charleston, TN
Back to Cessna 182F