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 ('8850408')
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 ('8850408')
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.
N54176Balzer Francis X · Paragon, INN54189Vintage Aircraft Sales LLC · Radnor, OHN54243Wacker George F Trustee · Los Angeles, CAN54469Mayes Brent L · Aurora, ORN54606Carpen Cos LLC · Rochester, NYN54751Ditcheit Joseph C · Union Grove, WIN55125Soare Sean C · Poplar Grove, ILN55156Tobias Aaron C · Clearwater, KSN57504Watson Mark T · Pensacola, FLN57509Glittenberg Donald R · Dectur, TXN57518Von Gottsegen Erik · Sweet Home, ORN57525Mantis Tactical Air And Space LLC · Titusville, FLN57527Scott Homer R Jr · Del City, OKN57529Bauer Lawrence L · Grand Raids, MIN57538Holcomb Garry M · Point, TXN57582Ball Bruce F · Van Nuys, CAN57583Isley Jason T · Sand Springs, OKN57680Kramer Allen R · Lewiston, IDN57699Yarbrough Deborah C · Somerville, TNN57729Radanof Robert T · Hernando, FLN57735Smith Paul R Jr · Hubbardston, MAN58028Hagar Johanne H · Morrisonville, NYN58032Mcnally Kerry J · Patten, MEN58033White Harry J · Scarborough, MEN58036Beazley Phillip B · Millbrook, ALN58040Ozarks Auto Show Inc · Hollister, MON58044Lazar Roman · Frenchtown, NJN58075Bentley William R · Citra, FLN58356Ghost River Aero LLC · Lewes, DEN58604Levison David · Cave Junction, ORN59702Garner Brian C · Buckley, WAN60202Hanson Robb D · Madison, SDN61720Ivey Joseph M · Poland, OHN61807Van Den Heuvel Grant P · Oconomowoc, WIN64733Easley Toby K · Lucama, NCN70374Atwood Matthew D · Palmyra, PAN73515Jacobi Joseph L · Mexico, MON825JLLefave Christopher J · Caldwell, IDN8347Kanca Christopher S · Effingham, NHN844TAHohmann Courtney P · Jacksonville, FLN87787Alamo Liaison Group DBA · San Antonio, TXN9045SBais Donald H · College Place, WAN9060KMorell Timothy S · Lino Lakes, MNN91032Kutschera Thomas C · Youngsville, NYN9115GHaberer Mark M · Elbow Lake, MN
Back to Taylorcraft DCO-65