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 ('2072821', '2070107')
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 ('2072821', '2070107')
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.
N95DMValley Gabriel P · Holden, MEN95JRKaiser Dennis · Portland, MEN9618HRegistration Pending · Wasilla, AKRegistration pendingN9620QObar Danny · Middleton, IDN9676HErickson Paul F · Wasilla, AKN9687HBell Gary E · Bend, ORN9697QCaltagirone Peter J · Lewes, DEN9705HMillers Oak Island LLC · Crosslake, MNN97DSWmg Aviation LLC · Ketchum, IDN97FAJalbert John E · Greenville, MEN9863QWattum Investments LLC · Kodiak, AKN98JBFlight1 Hsw LLC · Norwood, CON98PBFerry Services Corp · Cresson, TXN9910NRunner Douglas A · Ashby, NEN9930QBrawdy James · Clarence Center, NYN994RJAirline Pilot Careers LLC · Champlin, MNN9960NBoemer Steven E · El Cajon, CAN9987NUnited States Department Of Interior · Boise, IDN9FQualitair LLC Trustee · MichelstadtN9SGDurrett Aviation LLC · Anchorage, AKN9WCArapaho Air LLC · Walnut Grove, CA
Back to Cessna A185F