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 ('7150008', '7150065')
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 ('7150008', '7150065')
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.
N577KBDavid A Bush Inc · Hanford, CAN59TATailwinds Air Inc · Morganza, LAN628SECane John Paul · San Jose, CAN62TCRegistered aircraftN63JNDesert Air Inc · Phoenix, AZN640MCConston Kenneth M · Hopewell Junction, NYN671TCBraunstein Robert S · Seattle, WAN6861PFullerton Robert D · Houston, TXN687SAGerstein Lee · Park City, UTN692SABob Hannah Aviation LLC · Caldwell, IDN702DDJoyce Consulting LLC · Black Hawk, SDN72CUKuhlke K Lee · Englewood, CON72LRSchnell Michael L · Spearman, TXN731GVSolomon Mark Trustee · Wilmington, DEN747YVGreat Among The Nations Inc · Beverly Hills, CAN74DTEnjoy Life Flying LLC · Sunrise, FLN74MTKopair LLC · Saint Louis, MON771BB406 Mountain Air LLC · Bigfork, MTN777MMJsgjr LLC · Fife, WAN789FMRadio Flyer LLC · Fox Point, WIN7JNB & K Steel & Supply Inc · Ogden, UTN872WNsi Flight Services LLC · Idaho Falls, IDN908DBB36 LLC · Winter Park, FLN908PScott Kevin · Santa Fe, NMN928KMSchmoker William C · Eden Prairie, MNN973SThompson Peter L · Portales, NMN978JGColorado Orthopaedic Outreach Inc · Steamboat Springs, CON983DBBunke Jim Bradley · Denver, CON988JGSaratoga Aviation LLC · Wilmington, DEN989SAAir Kraft Spraying Inc · Timber Lake, SDN98JKIntagliata Joseph V · Hanna, INN998JGDragonfly Aviation LLC · Davie, FL
Back to Raytheon B36TC