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 ('7320001', '7320005', '05622SV')
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 ('7320001', '7320005', '05622SV')
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.
N279KQLmg-Rba LLC · Georgetown, TXN28NRJaars Inc · Waxhaw, NCN292KQNortheast Elite Aviation LLC · Oakland, MEN307RWRomeo Whiskey LLC · Klamath Falls, ORN309CQFelicidad Holdings LLC · Winter Springs, FLN31JA100-042 LLC · Menlo Park, CAN322N322 LLC · North Las Vegas, NVN333KKHocken Brett Trustee · Lake Oswego, ORN352CLMinam River Ranch LLC · Portland, ORN355MBMio LLC · Satellite Beach, FLN356BMfsr LLC · Rigby, IDN388EERegistered aircraftN404MAOlivia Aviation LLC · Minneapolis, MNN40GNNorthlend Logistics LLC · Belgrade, MTN426BCP-51 Investment LLC · Salem, ORN434JBInfinite Horizons LLC · Ruth, MIN456SBSurfbird Aviation I LLC · Seattle, WAN458TPValiair Limited Company Trustee · Casper, WYN465SPSamaritans Purse · Boone, NCN466BCBc Air LLC · Moses Lake, WAN466SPSamaritans Purse · Boone, NCN491KQParkwater Aviation · Spokane, WAN494KQJansair LLC · Seattle, WAN497BHMhoc LLC · Pensacola, FLN49BPBentalit Point Aviation LLC · Seattle, WAN4CMDavis Air LLC · Clinton, WAN500QKCat Air LLC · Miami, FLN501KQAnjucan 501kq Inc · Middletown, DEN504KQKodiak Aircraft Co Inc · Sandpoint, IDN50KQFaulconer Construction Company Inc · Charlottesville, VAN515CEParlueagle LLC · Montgomery, NYN528AGAh Aero Services LLC · Heber City, UTN528TGNorthward Bound LLC · Anchorage, AKN529NRMinnesota Department Of Natural Resources · Grand Rapids, MNN533PCJc Air Montana LLC · Missoula, MTN54BVGrigry Energy Inc · Monahans, TXN557HDKodiak Flyers LLC · Salt Lake City, UTN564BBAircraft Guaranty Corp Trustee · Oklahoma City, OKN565EState Of Washington · Olympia, WAN565HTHammar Air LLC · West Palm Beach, FLN56SFRemote Aircraft Leasing LLC · Missoula, MTN5728GSimpson Leasing LLC · Orofino, IDN572SGBluestone Aviation LLC · Billings, MTN5799Bas Part Sales LLC · Greeley, CON579CBWoodward Aviation LLC · Alpine, TXN581REpsilon International LLC · San Antonio, TXN60KQTurbine Options LLC · Fishers, INN621TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN626MMFlying Tricycle LLC · Oakland, CAN628TBJmw Kodiak LLC · Anchorage, AK
Back to Quest KODIAK 100