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 ('2072408')
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 ('2072408')
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.
N8384XVehrs Roger K · Roseburg, ORN8386XSchool Board Of Leon County Florida · Tallahassee, FLN8390XMoore Laura D · Sacramento, CAN8391XAmerican Aviation Inc · North Wilkesboro, NCN8394XBates Dale R · Cincinnatus, NYN8395XAccurate Aviation LLC · Spring City, UTN8396XKnierim Erik E · Puyallup, WAN8397XGeist Jeffrey A · Avondale, PAN8398XCummings Thomas H · Lewistown, MTN8399XWard Bruce · Fowlerville, MIN8400XBurlingame Craig D · Catlett, VAN8401XWilkinson Bert D · Sandpoint, IDN8402XDominy Geary B · Flint, TXN8404XHousel LLC DBA · Palm Harbor, FLN8407XDouthett Fontaine · Deland, FLN8409XAlbers Stanley F · Hazlet, NJN8410XFondy Investments LLC · Anchorage, AKN8411XOrr Kent C · Kearney, NEN8412XSuttle Joe Albert · Moody, ALN8413XPilot Pros Inc · Miami, FLN8414XRps-Lrs Investments Inc · Wilmington, DEN8416XBas Part Sales LLC · Greeley, CON8422XDundee Flying Club Inc · Rock Stream, NYN8424XHarvey Barrett K · Robstown, TXN8425XGarzione John E · Sherburne, NYN8430XMyers Glen · Grassy Butte, NDN8434XKopp Jeffrey L · Menomonie, WIN8437XHanshaw Joe W · Louisa, KYN8438XThomas Marc R · Elizabethtown, PAN8439XMonson Conrad · Wasilla, AKN8440XMenozzi Elizabeth M · Eastsound, WAN8442XReady Aim Flyer LLC · New Castle, DEN8446XSels Philip O · Magnolia, DEN8447XHill Gregory J · York, PAN8451XHorn Jamie D · Spicewood, TXN8452XLas Gaviotas 409 LLC · Safford, AZN8455XRandall Jason L · Altus, OKN8458XBass Cindy S · Highlands Ranch, CON8462XSmith Richard J · Jackson Springs, NCN8464XBistline Leland K · Fredonia, AZN8465XMaynard Craig A · Dedham, MEN8466XEagle East Aviation Inc · North Andover, MAN8469XEagan Timothy H · Casa Grande, AZN8475XKeller Albert Peter Jr · Lemmon, SDN8477XSikes James E III · Kirbyville, TXN8479XRobinson Jason M · Wilsonville, ORN8481XN8481x LLC · Canyon, TXN8488XRotormate LLC · Royse City, TXN8491XHeauser Mark · Grass Valley, CAN8493XDavis Michael L · Rowland, NC
Back to Cessna 172C