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 ('7100510')
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 ('7100510')
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.
N24904Bob Hoover Academy · Salinas, CAN24905Cochran David · Richmond, KSN24907Tracy Johnny L · Troy, MON24909Mathis James · Lebanon, PAN24910Harvey Douglas W · Shreveport, LAN24928Hancock Carl M · Glendale, AZN24934Carter Benjamin F · Colusa, CAN24935Cavanaugh Air LLC · Addison, TXN24937Evenson Kenneth M · Eveleth, MNN24946Woodworth Richard Z · Burlington, WVN24960Smith Glenn A Trustee · Winnisquam, NHN24962Tvpx Ars Inc Trustee · North Salt Lake, UTN24SNMoerman Leendert · Houston, TXN25033Armstrong John Russell Jr Trustee · Commerce, TXN25045Schwankl Michael J · Wasilla, AKN25070Brill Bernard M · Pleasant Grove, CAN25099Waterwings Seaplanes LLC · Hoover, ALN250KEThomsen Nickolas J · Bend, ORN2511ZHensley Ty G · Lake Wylie, SCN25702Reynalds Brothers Aviation LLC · Englewood, CON25709Excon Aviation LLC · Magnolia, TXN25725Ixl Inc · Sulphur, LAN25727Dean James J · Sanford, NCN25752Millsaps David C · Tuscumbia, ALN25758Price John DBA · Bennington, KSN25769Wings Of Eagles Discovery Center · Horseheads, NYN25786Bertrand Jarett · Funk, NEN25797Mayall William J · Santa Cruz, CAN25806Davis Susan J · Castroville, CAN25817Peck Brian D · Loomis, CAN25825Peterson Scott W · Garfield, KSN25830Surette Rosemarie · Vail, CON25869Guilbault Matthew F · Averill Park, NYN25870James Bradley R · Denver, NCN25885Sprigg James A Trustee · Dade City, FLN25923Airport Farms Aviation LLC · Tarkio, MON25940Pennau Wade S · Wautoma, WIN25960Zabinski Ted W · Voorheesville, NYN25964Sproul Wendell C · Hermon, MEN25972Weaver Christa M · Epping, NHN25973Westfall Michael T · Woodstock, GAN25HJames Andy · Crown Point, INN26017Walker Ronald · Lawrenceburg, TNN26021Gerber Daniel J · Tolland, CTN26042Peck Nathan M · Leavenworth, KSN26044Palm Springs Air Museum Inc · Palm Springs, CAN26046Roberts Michael R · Mcminnville, TNN26057Nalls Aviation Inc · Lusby, MDN26074Davenport Aviation Inc · Wilmington, DEN26081Schuman Jason · Corsica, SD
Back to Piper J3C-65