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 ('2072734')
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 ('2072734')
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.
N3641CFeldmann D Joshua · Epworth, IAN364MGCw Aviation LLC · Washta, IAN3651CHately William · Anchorage, AKN3662CArmi LLC · Nevada, IAN3665CN3665c LLC · Otsego, MNN3666CStrauss Kenneth W · Vashon, WAN3671CCharlie Aviation LLC · Philpot, KYN3672CWells William · Cary, NCN367CRRay Samuel · Spring Hill, TNN3684CFly Away Aviation LLC · Folsom, LAN3689CR D Management LLC · Central City, NEN368CPWilliams Truman V · Robbinsville, NCN3695COrton Dennis · Mead, CON3696CTb Services LLC · Huntsville, ALN36AFLewis Richard M Jr · Deltaville, VAN3726CRogers Glenn A Jr · Sedona, AZN3747BAviation Specialists Inc · Gonzales, LAN375JTD2 Aviation LLC · Chesterfield, MON37CGLichty Lisa · Bodega Bay, CAN3GXSearle Kenneth · Bigfork, MTN3VCGreen John T Trustee · Kettering, OHN400BTN Ranch LLC · Missoula, MTN400NAAircraft Guaranty Corp Trustee · Oklahoma City, OKN404XXInternational Air Services Inc Trustee · Carson City, NVN405JHTss Flying Club Inc · Bethesda, MDN40ATN40at LLC · Lewis Center, OHN4105CJohnson Rodney R · Roseburg, ORN4106CAir Data Solutions LLC · Natchitoches, LAN410SEConner Gary Dean · Cypress, TXN41139Blair Mark Winston · Zachary, LAN4115CHails Betsy B · Montgomery, ALN411TSTango Sierra Aviation Inc · Stuart, FLN412KJTudor Jeff · Orlando, FLN4148CMjolhus Knut G · Amarillo, TXN414FHSewell Stephen A · Navasota, TXN4153CJet Care Corp · Roseville, CAN4160CNewman Holdings LLC · Dallas, TXN4164COld Blue Solutions LLC · Harvest, ALN4166CBas Part Sales LLC · Greeley, CON4175CSalciccioli Christopher · Joshua Tree, CAN4183CLockhart Curtis M · Bay Village, OHN418PRHunnicutt Gerald E · Hendersonville, NCN422TTTravland Christopher L · Austin, TXN4244CBusking Ryan · Houston, TXN4245CLogan Gregory A · Chouteau, OKN4246CDodson International Parts Inc · Rantoul, KSFirst renewal noticeN4248CSchneider Franz E · Bacliff, TXN42GVBlahnik Vance Thomas Trustee · Eden Prairie, MNN430DBIkard James C · Shelbyville, TNN4373RKlc Associates · Unionville, CT
Back to Cessna R182