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.
N73387Bartley Darrell Jr · Somerset, KYN73388Wings Over Texas Holdings LLC · Denton, TXN73391Holdgate Irvin F · Englewood, FLN73395Quick Caleb B · North Newton, KSN73398Wintons Wings LLC · Bardstown, KYN73399Stone Mary A Trustee · Weeki Wachee, FLN733TDFrantzen Elizabeth · Davie, FLN73401Sage Kathlene A · Bass River, MAN73407Wxly Aviat LLC · Gastonia, NCN73411Elwood James C · Jupiter, FLN73419Cook Thomas M · Palmer, AKN73420Globemaster Services LLC · Saint Jacob, ILN73423Weck Geoffrey E · Woodstock, ILN73424Quincy Flying Club Inc · Quincy, ILN73425Wings Over Texas Holdings LLC · Denton, TXN73428Johnson Brent C · Appleton, MNN73429Anson Flyers Club Inc · Wadesboro, NCN73433Salvation Neighborhood Development Corp · Riverside, CAN73434Monette Verne G · Anchorage, AKN73435Air America Spares LLC · Daytona Beach, FLN73439Umo Flight School LLC · Mount Olive, NCN73441Stein Aporn U · Pepeekeo, HIN73450Penn Yan Flying Club Inc · Penn Yan, NYN73451Airward Inc · Columbia, CAN73452Hodges Jonathan D · Port Orchard, WAN73453Mfa LLC · Mount Pleasant, SCN73454Yr-Aircraft Leasing LLC · Soldotna, AKN73455101 Flight LLC · Waterford, MIN73456K E F Enterprises · Plymouth, MAN73457Bmg Aviation Inc · Bloomington, INN73459Stowers Joshua S · Niceville, FLN73461Monk Crafton L · Saraland, ALN73462Farkas Dan · Wyoming, MIN73464Knight Kevin J · Fort Wayne, INN73468Tnt Airworks LLC · Hibbing, MNN73472Lajova LLC · Amarillo, TXN73473Lauro Michael J · Kailua Kona, HIN73477Nationwide Aviation LLC · Hudson Oaks, TXN73481N73481 LLC · Eaton, CON73486Begley Edward · Glasgow, KYN73487Spiess Michael Trustee · Montague, CAN73489Total Flight Aircraft Leasing LLC · Apex, NCN73496Heartland Aviation Inc · Alliance, NEN7349814a Flying Club Inc · Mooresville, NCN73502Greenbrier Valley Flyers Inc · Wht Sphr Spgs, WVN73504Abriam Darryl · Jacksonville, FLN73505Tex Air LLC · Springfield, MON73508Hoyt Max A · El Dorado, KSN73509Saffron Skies Aviation LLC · Pleasant Hill, CAN73510Adams Rodney G · Topinabee, MI
Back to Cessna 172M