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 ('2072732')
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 ('2072732')
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.
N96583Inconceivable LLC · Wilmington, DEN96590Simple Air LLC · Ankeny, IAN96594Logbook Lift Inc · Monroe, LAN96598Hawkins Curtis F · Monette, ARN96602Hofer Galen J · Denver, CON96607Bailey Joe D · Trophy Club, TXN96634Standefer Wayne B · Highland Village, TXN96639Ringel John S · Long Beach, CAN96642Bingham Ned R · Redmond, WAN96654Mcgahey Timothy P · Mccall, IDN96665Sharp Darren · Greeley, CON96668Hollister Flying Club · Tulare, CAN96673Seaton Bradley G · Rio Verde, AZN96679Jacobi Joseph L · Mexico, MON96683Otter Wings Inc · Evansville, WIN96704Skylens LLC · Hammond, LAN96713Mountain Top LLC · Lafayette, LAN96715Gomez Ben A · Cullman, ALN96720Nb Air LLC · Dover, DEN96725Civil Air Patrol Inc · Maxwell Afb, ALN96733Thompson Kyle · Babcock Ranch, FLN96737Smith Flying Farms LLC · Leoti, KSN96739Euroaviation Inc Trustee · KematenN96742Parsons Lisa A · Shade Gap, PAN96749Southern Aircraft Consultancy Inc Trustee · Casper, WYN96783Campbell George A · Aubrey, TXN96784Arnett William J · Heber Springs, ARN96798Curl Kathryn Ann · Idaho Falls, IDN96804Petecraft Aviation Services Inc · Plains, GAN96810Gordin Michael E · Lakeland, TNN96814Airplane Leasing LLC · Jupiter, FLFirst renewal noticeN96821Tdm Aviators LLC · Madison, ALN96840Brad Force One LLC · Terre Haute, INN96843Southside Air LLC · Bakersfield, CAN96844Flying Truckster LLC · Denver, CON96852Inland Northwest Flyers LLC · Spokane Valley, WAN96883Knash Partners Nwa LLC · Summers, ARN96885Chord Line LLC · East Hampton, NYN96893Neu Rick L · Kingwood, TXN96906Nulisch Justin · Del Rio, TXN96919Mckitrick Brad L · West Jefferson, OHN96923Green David C · Milford, IAN96928Jurkowski Raymond · Germantown, NYN96929Ware Joseph B · Angleton, TXN96943Porta Michael W · Old Bridge, NJN96949Pittman William Greg · Anchorage, AKN96952Gospel Ministries International · Collegedale, TNN96968Shaw Stephen A · Sherwood, ORN96977Couch Christopher · Huntertown, INN96988Wenner Aaron · Tehachapi, CA
Back to Cessna 182Q