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 ('2073709', '2073710')
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 ('2073709', '2073710')
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.
N52871North Cardinal LLC · Crookston, MNN52878Martin Carver Jessica · Bowling Green, KYN52881Cardinal Air · Gold Hill, NCN52882Qdp Inc · Cincinnati, OHN52885Foster David F · Potomac, MDN52890Schlafly Sheila B · Miami, FLN52894Craren Michael J · Holliston, MAN52908Ichinose Ryan · Fort Worth, TXN52930Sir Grantham Of Kloofbear Inc · Wilmington, DEN52936Reimer Dean R · Yuma, AZN52944Masiero Christophe D · Winter Garden, FLN52946Pluntze Stephen C · El Segundo, CAN52987Lewis Nathan A Trustee · Watsonville, CAN52990Hurley Drew M · Port Orange, FLN52BJTca LLC · Fountain Hills, AZN53026Oehl Robert · Jacksonville, FLN53029N53029 Cardinal LLC · Rosharon, TXN53035International Air Services Inc Trustee · Carson City, NVN53036Aviation Gt Inc · Wilmington, DEN53053Taylor Jesse L · Venus, FLN53061Flying Ducks Aviation LLC · Newport, ORN53073Zahnow Todd · Raub, NDN53080Isaacs Christopher W · Advance, NCN53088Sangal Shiddhartha · Annandale, NJN53103Top Flight Aerial Photography LLC · Georgetown, TXN53108Prindle Steven G · Seaford, DEN53152Griffin Bruce H · Trenton, FLN53158Schoen William R · Madison, CTN53160Benson Michael H · New Castle, PAN53175Kendall Investment Corp · Three Lakes, WIFirst renewal noticeN53194Jagav LLC · Lewes, DEN534DWValiair Ltd Co Trustee · Casper, WYN545PZLake Placid Flying Service Inc · Lake Placid, NYN548FDScattertown Holdings LLC · Montross, VAN548MMLittle Atlas Air LLC · Montgomery, ILN552KKing Monte L · Kerrville, TXN555DDBnc Aviation LLC · Georgetown, TXN555WWAdams John G · Marietta, GAN55MPCommanche LLC · Slatington, PAN57EAEwing Andrew M · Santa Rosa Beach, FLN5EJJones Eric M · Southbridge, MAN5RBBanasik Associates Inc · Columbus, OHN606RWInternational Air Services Inc Trustee · Carson City, NVN612DMRegistered aircraftN612HKDickey Stephen H · De Leon, TXN626LDAerofleet LLC · Oldsmar, FLN628RGKozubek Richard R · Shady Shores, TXN657SCKruse Shannon E · Republic, MON65PTBs Aviation LLC · Portland, ORN661KFurrow Terry · Hinton, OK
Back to Cessna 177RG