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 ('2072424')
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 ('2072424')
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.
N8065LDream Big Aviation LLC · Mount Juliet, TNN8067LAviation Guys LLC · Charleston, WVN8068LMason David M · Destin, FLN8072LBobo Jason A · Lampasas, TXN8076LWay Properties LLC · Tumbling Shoals, ARN8077LAndrews Carson D · Hartsville, SCN8078LSale Reported · HawkestoneSale reportedN8079LHurricane Joaquin LLC · Umatilla, FLN8081LAerowood Aviation LLC · Monroe, NCN8082LBurns Jeremiah W · Westerville, OHN8085LDowns Warren · Dillingham, AKN8087LBawden Scott L · Saint George, UTN8088LMarciano Raymond P · Cleveland, OHN8091LSzarek Carlee B · Los Osos, CAN8093LNevins Mark B · Gresham, ORN8097LPeters Aero Plus LLC · Freeland, MIN8098LJordan James R Trustee · Hermon, MEN8099LMateaki Koreen · Anchorage, AKN8101LRegistration Pending · Minden, LARegistration pendingN8103LSoaring Mrt LLC · Lake Charles, LAN8105LIowa Skyhawk LLC · Charles City, IAN8107LConrad Adam C Jr · Duncansville, PAN8109LVajgrt Richard Eugene · Mobile, ALN8110LMiller Brian T · Savage, MNN8113LN8113l LLC · Auburn, INN81424Wbair LLC · Wills Point, TXN814BMMcdaniel Robert L · Columbia, ILN8150LKal Aero Flight Instruction LLC · Mattawan, MIN8151LBrown Gary D · Rainbow City, ALN8152LBowman Douglas M · Elyria, OHN8153LTr Air LLC · Kenton, OHN8157LWinfrey Walter A Trustee · Auburn, CAN8158LBockman Peter Jr · Anchorage, AKN8160LGarcia Geoff M · Tecumseh, OKN8161LNexten Flight Academy · Riverside, CAN8164LBowtie Properties LLC · Dadeville, ALN8166LBlackerby Dennis N · Wilsonville, ALN8167LVan Pelt Wilbur F · Seattle, WAN8169LApex Flight Training LLC · Houma, LAN8171LSam Aviation LLC · Long Beach, CAN8176LAdams David F · South Lyon, MIN81775Flying B Aviation LLC · Waynesboro, TNN8177LDenton Scotchie M · Calhoun City, MSN8178LMalone Traci L M · Effingham, ILN8179LExecutive Wings LLC · Bolivar, TNN8180LManser Andrew R · Neenah, WIN8184LVanderlaan Dirk C · Reno, NVN8186LBolsover Douglas J Sr · Cameron Park, CAN8190LOlsen Curtis O · Lindon, UTN8192LSteinmetz William · Lakeville, IN
Back to Cessna 172H