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 ('2074002')
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 ('2074002')
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.
N5233GArsenault Don S · Round Rock, TXN5234GPorter David E · Woodstock, GAN5237GTeets Trent D · West Fargo, NDN5240GBobbys Landing LLC · Pembroke Pines, FLN5242GGray Eagle Farms LLC · Southampton, NJN5247GKushnir Borys G · Tamuning, GUN5255GSetian Peter · Ennis, TXN5258KFargo Air Museum · Fargo, NDN5259GSnowdog LLC · Litchfield Park, AZN5262GDoerstling Alexander Wolfgang · Waco, TXN5263GWarhawk Air Museum · Nampa, IDN5264GMorris Thomas Lee · Sonoma, CAN5269GBrachtenbach Eric · Hill City, KSN5277GRussell Michael E · Sumner, TXN5278GCostilow Bobby W · Griffin, GAN5281GGravenstede Nelson F · Newton, NJN5284GAbc Farms Inc · Spooner, WIN5285GGlobe Motorcycles Limited Inc · Pembroke Pines, FLN5286GPaliughi Ronald D · Fresno, CAN5287GNoyes Stephen S · Newburyport, MAN5289GRounds Chris · Waller, TXN5291GSimmons Aviation Services LLC · Pawcatuck, CTN5292GSideline Services LLC · Pearland, TXN5293GShamrock Aviation LLC · Seabrook, NHN5294GHainline Charles H · Friendswood, TXN5296GTobul James R · Jackson, WYN5298GDmgf LLC · Bertram, TXN5299GSoloway Gary F · Lebanon, TNN5300GRobinson David L · Salt Lake City, UTN5301GBarnard Jorge A · Wilsonville, ALN5302GBreunig Scott · Newark, ILN5303GTrotter Steve · Roanoke, TXN5306GArno Christopher S · Dover Foxcroft, MEN5307GBogen Alfred T III · Brandon, MSN5308GEast Iowa Air Inc · Bennett, IAN5309GMarshall Randall · Addison, TXN5310GBrown Helicopter Inc · Pensacola, FLN5313GKem Aviation Inc · Harrison, IDN533PEDelaware Aviation Museum Foundation · Georgetown, DEN53650Phillips Michael A · Bozeman, MTN5472VGivens Thomas A · Southern Pines, NCN5673BDoobalachie Fish Camp Inc · Aberdeen, WAN615JCPutnal Recie R · Myakka City, FLN62364O'Leary James M · Newark, CAN6393TAkin Robert Edward · Placerville, CAN64553Drew Mark · Phoenix, AZN64835Vermont Flight Academy · South Burlington, VTN65AGSouthern Airmotive Inc · Texico, NMN6735QHoddenbach Jim · Woods Cross, UTN677RHWarbird Heritage Foundation Inc · Waukegan, IL
Back to Cessna 305A