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 ('2072418')
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 ('2072418')
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.
N9645HSantiago Diana L · Juana Diaz, PRN9645VOak Ridge Flyers Inc · Oak Ridge, TNN9647QKaeni Law Group Inc · Santa Ana, CAN9648HSaunders Larry F · Sulphur Springs, ARN9648QGreen Bay Flying Club Inc · Krakow, WIN9648VGrove Kaylene · San Diego, CAN9649VLagorce Victor X · Owasso, OKN9650QVon Graff Kurt · Pennington, NJN9650VPittman Michael Sr · Chandler, AZN9651VHussain Mahmoud Taimour Said · Miami, FLN9652VBrown Keno · Athens, TXN9653QMikeska Rudy L · Taylor, TXN9654QFly Pioneer Valley LLC · Gill, MAN9654VN9654v LLC · Lakeland, FLN9656QMccort Daniel R · Pensacola, FLN9657VChorman Spraying LLC · Milton, DEN9659HJd Griffin LLC · Wilmington, DEN9659QMacrafic Bruce A · Garden City, MNN965MSMt San Antonio College · Walnut, CAN9660HCdb Group Holdings LLC · Sheridan, WYN9662QHomiller Robert S · Bear, DEN9662VLevel X Aviation LLC · Royal Palm Beach, FLN9665HDouble Bridges Aviation LLC · Enterprise, ALN9665QAlldredge Aviation · Auburn, WAN9665VAircraftsmen LLC · Heber City, UTN9666HMorton Tamera L · Belpre, OHN9666VMedia Stew LLC · Carson City, NVN9667VWilliams Burla L · New Cumberland, WVN9668VMurphy David J · Humble, TXN9669QAce Flight Center Inc · St Thomas, VIN9670HAllen Max R · Jefferson, GAN9670QSalad Days Aviation LLC · Fargo, NDN9670VNichols Timothy J · Dixon, CAN9671VSkywarrior Flight Training LLC · Pensacola, FLN9672VAirline Transport Professionals Corp Of USA · Wilmington, DEN9673VTaylor Charles E · Killdeer, NDN9676VCronsell Christopher A · Muskego, WIN9677QKodiak Flying Club Inc · Kodiak, AKN9678HBuckles Edward W II · Mechanicsburg, ILN9678QNorthgate Aviation Inc · Chico, CAN9679QEagle Sky Patrol Inc · Deadwood, SDN967JRAmoroso Ricardo C · Powder Springs, GAFirst renewal noticeN9680QAircraft Guaranty Corp Trustee · Oklahoma City, OKN9681HDavis Lester Jr · George West, TXN9682HCloutblazer LLC · Sacramento, CAN9682VBanks Michael R · Macon, MSN9683HCook Samuel Jordon · Thibodaux, LAN9683QBering Capital LLC · Anchorage, AKN9684QOgden Laurence B · Weaverville, NCN9685HBoys Will Fly LLC · Mapleton, UT
Back to Cessna 172M