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 ('2074242')
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 ('2074242')
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.
N7664QDluhos Robert A · Hilton Head, SCN7667QBergenty William F DBA · Plainville, CTN7668QRiester Robbin W · Navarre, FLN7670QRivers Willie G · Atlanta, GAN7678QEshowe Aviation Inc · East Peoria, ILN7681QArizona Sky Ventures LLC · Lewes, DEN7685QStrowhouer William J III · Media, PAN7687QPfs Air Inc · Yellville, ARN7688QKallio Eric M · Gonzales, LAN7700QConcept Sales Inc · Hartford, SDN7710QRegistered aircraftN771BCDavid Slack · Hamersville, OHN7723QBackyard Aero LLC · Rockville, INN7724QBned LLC · Tupelo, MSN7727QDivinia Darin D · Graham, TXN7729QMowinski Frank R Jr · Ray, MIN7739QHarding William R Jr · Quinlan, TXN7742QStarr Brian Layton · Joliet, MTN7743QCrampton Scott C · La Jolla, CAN7744QRegistered aircraftN7760QBode Aviation Inc · Albuquerque, NMN7762QAnagnos Nick C · East Moline, ILN7763QJones Aviation Inc · Biggs, CAN7768QGress Gabrielle M · Bartow, FLN7769QValla Joseph P · Santa Clarita, CAN7773QValentine Russell P · Saint Petersburg, FLN7778Q1974 310q LLC · Redmond, WAN777CGGilbert Charles L · Belleair, FLN777DRPollock Jordan E · Nolensville, TNN7782QFanning Fred W · Fairlawn, OHN7792QSchultz Todd · Bakersfield, CAN7793QJupiter Flight Service And Investing LLC · Lithonia, GAN7794QRg Aviation Inc · Wilmington, DEN7829QCavok Aviation LLC · West Fargo, NDN7835QChannell Robert Douglass · Moreland, GAN7872QSinkovich Peter I · Phoenix, AZN7873QWallis Aircraft Inc · Clifford Township, PAN7887QBeiser Ned E · De Soto, TXN7893QDatchcorr LLC · Chattanooga, TNN7899QCounty Farms LLC · Mars Hill, MEN790DMNostalgair/Sky Adventures Inc · Vero Beach, FLN7928QS & L Aviation LLC · Ashland, OHN7933QRegistered aircraftN7935QHawkins Justin · Los Lunas, NMN7951QClifton James Dvid · Manchester, TNN7953QGoodin David J · Yerington, NVN7960QHartwig Donald J · Riverside, CAN7972QJett Aviation LLC · Success, ARN7997QSilva Robert L · Bakersfield, CAN799JBNiner Jay Bee Aviation LLC · Middletown, DE
Back to Cessna 310Q