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 ('0690009', '060009Y', '05622D3')
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 ('0690009', '060009Y', '05622D3')
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.
N199CHSloan Jacob · Gretna, LAN200RVBrowning Robert · Washington, DCN202LYBoyd Philip S · Amarillo, TXN203GEEdwards Graeme M · Bulverde, TXN212EXCowley Rollin J · Hampton, ILN212GKBartolett Douglas · Auburndale, FLN212TFTaylor Jonathan W · Mcminnville, ORN212WCMyers David V · Northport, ALN213UDFlying Bear LLC · Cynthiana, KYN214LACurry Jack Jr · Cocoa, FLN214ZStephens Stacy · Mckinney, TXN215RHHelfrich Robert J · Aurora, CON217EA217ea LLC · Iowa, LAN217TFLane Ronald W · Dundalk, MDN218TFBussard John Timothy · Hagerstown, MDN218VCRicciardi Joseph D · Crystal Lake, ILN219EMWardle Michael R · Salt Lake City, UTN2222VSaldarriaga Pedro J · Titusville, FLN223HDEwing Michele D · Vancouver, WAN233PDButler Dale K · Hillsborough, NCN233TXHurd James K · Boerne, TXN233VABaggerman Robert W · Niceville, FLN233WBWmbgrv12 LLC · Williamsburg, VAN234LFLindbergh Flyers Inc · Marlborough, CTN235JVLytle Richard A · Albany, ORN235VARegistration Pending · Youngstown, NYRegistration pendingN236VAAdventure Aviation LLC · Waukesha, WIN237VAAviate LLC DBA · Hazelton, IDN237VWVaughan Jeffrey H · West Chester, PAN238VALizard Air LLC · Kalispell, MTN239VAAviate Pilot Academy LLC · Wichita, KSN23KLHerem Gary L · Red Lodge, MTN240VAPacific Flight Academy LLC · Honolulu, HIN241DMMillsap Dennis W · Winterville, NCN241RLHollen Ray L · Kingsland, GAN241VAWing William F · Hopkinton, MAN242TFCohen Harvey · Naples, FLN242VAAdventure Aviation LLC · Waukesha, WIN243VAChi Aerospace Inc · Portsmouth, NHN244VAFlying Dreams Rv LLC · Louisville, KYN245VASells James O · Peachtree City, GAN246RVPigozzo Gino · Grant Park, ILN248VAJones Greg R · Louisville, KYN249VAHeger John T · Clearwater, FLN24VAMason Jerry J · Lebanon, ORN24VLWitkin Alan M · Port Orange, FLN250VARegistered aircraftN251VACoats American LLC · Henryville, INN253VAPueo Aircrafts LLC · Honolulu, HIN255VAStokes Robert A · Golden, CO
Back to Vans RV-12