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 ('2072704')
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 ('2072704')
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.
N4730DRd Simpson Consulting LLC · Luling, TXN4743DEss Partnership LLC · Waterford, MIN4745DRoman Steven T · Burgettstown, PAN4748DLifting Spirits Research LLC · Pensacola, FLN4750DGraves Frank C · Nocona, TXN4751DMoore Johnathan D · Guymon, OKN4756DVertical Investment Strategies LLC · Henderson, NVN4758DBurt William G · Tullahoma, TNN4761DNordstrom Anne D Trustee · Walpole, NHN4766DHutchison Frank J · Tucson, AZN4767DFulton Daniel M · Blacksburg, SCN4768DBoyd Amy L · Kila, MTN4770DNapier Michael D · Russell, KYN4781DGipe Douglas A · Malvern, IAN4782DSwalling Matthew C · Wasilla, AKN4786DPierce Stephan L · Graham, TXN4790DGlobal Navigator LLC · Anacortes, WAN4791DBoan Randall P · Milton, IAN4795DStemprok Roman · Corsicana, TXN4799DDressen Donald L · Fruitland, IDN4802DCentral Pennsylvania Soaring Association Inc · Lemont, PAN4807LEddy Richard C · Hurricane, UTN4809DRanger Timothy R · Anchorage, AKN4811DAbidance Inc · Winthrop, WAN4815DBodeen Lance A · Eagle River, AKN4817DWirt James · Goldsby, OKN4822DRegistered aircraftN4825DHitec Construction Services Inc · Lincoln, CAN4826DTurbine Training Center Inc · Manhattan, KSN4827DWebber David A · Delta Junction, AKN4828DNisbet William T · Driggs, IDN4831DVogel Paul R · Valparaiso, INN4832DM & D Adventures LLC · Ozark, MON4833DSmith Shayne A · Greenville, TXN4834DGrismer Larry Trustee · Hemet, CAN4836DRegistered aircraftN4837DRees Matt A · Spokane, WAN4839DRosecrans Robert · Emmett, IDN4842DTablerock Cattle Co LLC · Lacrosse, WAN4844DLewis Joseph W · Decatur, TXN4846DYoung Jason · Anchorage, AKN4853DCrosgrove Shawn R · Riverton, UTN4855DRegistration Pending · Peachtree City, GARegistration pendingN4857DMarkwood Bruce A · Anchorage, AKN4858DRostron Kenneth E · Eagle Nest, NMN4860DWeinheimer Jeffrey T · Onida, SDN4861DThornquist Robert K · Anchorage, AKN4862DHixson G C · Readyville, TNN4866DBetts Thomas L · Fort Collins, CON4869DCutler Donald R · Bolivar, MO
Back to Cessna 182A