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 ('1153605', '1153601')
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 ('1153605', '1153601')
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.
N507TTCampo Feliz Aircraft Services LLC · Miami Lakes, FLN51ALGalaxy Cerne LLC · Burlington, VTN51CLDocs Flight Training LLC · Prescott, AZN51KPShoreline Aviation LLC · Waco, TXN523EFAircraft Partner Holdings Inc Trustee · BerlinN525GATechnical And Aviation Services LLC · Salisbury, NCN53AJG Bongard LLC · Fort Myers, FLN557PAPlatinum Leasing LLC · Fate, TXN55ZMAngel V LLC · Gig Harbor, WAN586HPBell Design LLC · Atlanta, GAN6008SAustin Aerial Media LLC · Pflugerville, TXN600CPColumbus Paper Company Inc · Columbus, GAN600PGParis Jet Inc · Great Falls, VAN6010SR&R Aviation LLC · Wilmington, DEN6011SWelch Troy O · Weatherford, TXN6028SHazellief Joe · Okeechobee, FLN6032SRenk Brett J · Sun Prairie, WIN6048C4g Aerobatics LLC · Saint Petersburg, FLN60500Erda LLC · Wilmington, DEN6051SCya Aviation LLC · Estero, FLN6060YN6060y LLC · Friendswood, TXN60AB4 Girls Aircraft LLC · Wilmington, DEN60FVMp3 Aviation LLC · Nocona, TXN60NZBlackley Donald W · Cornelius, NCN6144CLacour Chad · Baton Rouge, LAN615RMMann Robert F · Oshkosh, WIN621WBRicky Bobby USA LLC · Kalispell, MTN626NDay William B · Conroe, TXN640SCBest Crane & Equipment Co LLC · Wilmington, DEN64AHFlying Machines LLC · Grand Ledge, MIN64EJLws Flight Service LLC · Lewiston, IDN6641ZVineyard Andrew L · Laguna Hills, CAN66HPTwin Lakes LLC · Englewood, CON66HWStender Aviation D LLC · Huntsville, ALN66PLValiair Lc Trustee · Casper, WYN678AJAj Air LLC · Brookfield, WIN6LWN195sd LLC · Senatobia, MSN707TSShortt Aircraft Leasing LLC · South Lyon, MIN711AAPro-Star Aeronautical Inc · Morrison, CON712J4j Aviation LLC · Perryton, TXN717VSJacobs John D · Chicago, ILN71WWLarson Christopher L · Sheboygan, WIN720PMPeter J Messina & Associates Ltd · West Chicago, ILN721TRDe Anza Building & Maintenance Inc · Los Altos, CAN724RKChasing Ace LLC · Cresson, TXN729BCNeedy LLC · Maud, OKN74BAAns Electric LLC · Macon, GAN766JWPetrol Properties Inc · Springfield, MON767MRSpn Construction Inc · Brownsville, TXN776DRDel Rossi Anthony J · Key Largo, FL
Back to Beech B-60