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.
N9123HTwenty Three Juliet LLC · Tyler, TXN9127HMoraine Flying Club Inc · Butler, PAN912YAChewelah Flyers · Chewelah, WAN9131HStroemsuik Kristian · Strasburg, VAN9134HRegistration Pending · Kalispell, MTRegistration pendingN9137HPilots Flying School LLC · Englishtown, NJN9138HMojo Flight Group LLC · Gainesville, GAN914JDAis Wings LLC · Grand Rapids, MIN914RRMartinez Jeff L · Lewistown, MTN914ZSkylens LLC · Hammond, LAN91507Eagle Aviation LLC · Spearfish, SDN9150HN9150h LLC · Charleston, SCN9151HFirst Flight Corp · San Diego, CAN9153HSambriski Michael Daniel III · Long Beach, NYN91553Simpson Josiah J L Trustee · Shelburne, MAN9156HSolar Flying Club · Grimes, IAN9158HParrish Aviation Flight Academy LLC · Southlake, TXN91596West Michigan Flying Club Inc · Norton Shores, MIN9159HHess Garrett · Fullerton, CAN915CMVaayu Aviation LLC · Newark, CAN915LCardinal Flying Corp · San Jose, CAN915WBBordelon Warren P · Breaux Bridge, LAN9160HTodd Media Inc · Tuscaloosa, ALN9161HAir Athens LLC · Athens, GAN9162HStratus Aviation LLC DBA · Vacaville, CAN91673Martin Charles W · Twain Harte, CAN9171HSonday Terrance · Spring, TXN9173HSmitty 172 LLC · Rockford, MIN91751Aviators Cooperative LLC · Colorado Springs, CON9176HSky Walker Flight School LLC · Adrian, MIN9177HLind Enterprises LLC · Manistee, MIN91793Oexmann James Bennett · Lexington, KYN9179HMeteiver Lawrence J · Elkhart, INN91813Fallbrook Fly Girl LLC · Lakeside, ORN91823Perra John James Trustee · Gardnerville, NVN9182HMouton Charles · Gladewater, TXN9185HFlyit LLC · Washougal, WAN91862Aire Services LLC · Barrigada, GUN9189HPendergrass Aviation Inc · Demopolis, ALN918VPVanderpool Robert W · Red Devil, AKN91925Rl Aviation LLC · Miami, FLN9193HPrairie Flyers Flying Club · Eudora, KSN9196HLaplante Rene J · Bellingham, WAN91984A-Line LLC · Kent, WAN91PAHigh Wing Air LLC · Arnold, MON91PMRunrich LLC · Newport News, VAN92006Troughton Jill A · Spring Hill, FLN92014Shotwell Land Management Co LLC · Jackson, MSN9201HSparkwizard LLC · Greenville, RIN92026Haltom Frances F · Alva, OK
Back to Cessna 172M