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 ('7150030')
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 ('7150030')
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.
N76HLDiamond A Aviation LLC · Amarillo, TXN774KDSitatunga Springs LLC · Milwaukee, WIN777DSUSA Dent Co LLC · Wichita, KSN777JFIntrapack Industries Inc · Dallas, TXN784MASien Air LLC · Missoula, MTN784PCCarlyle Air LLC · Morristown, TNN808CSSierra Alpha Aviation LLC · Brookings, SDN808SQFinal Approach Investments LLC · Smithville, MON80VRValor Jets Inc · Osprey, FLN810WTAarl Services LLC · White Pigeon, MIN817WCollier Air LLC · Sioux Falls, SDN833PSPremier Aircraft Trading Services Inc · Lewes, DEN835ZTZotec Aviation LLC · Carmel, INN84VAA Street LLC · Saint Paul, MNN855JBGeorge Inc · Wilmington, DEN85PLPremier Wings LLC · Portland, ORN888MNFlying Moose LLC · Prescott, AZN88ERPremier 1 Aviation LLC · Evansville, INN88MMCraig Air LLC · Scottsdale, AZN8PJFaith Life International Inc · Sarasota, FLN903MTSouthern Star Holdings LLC · Safety Harbor, FLN929SSGmn Joint Air LLC · Dexter, MON92SHCoffman Air LLC · Liberty, INN956MCMichael Cowen Equipment Leasing LLC · San Antonio, TXN957RDTailwind Aviation Llp · Bismarck, NDN964TSHsi Aviation LLC · Wichita, KSN969RE390 LLC · Las Vegas, NVFirst renewal noticeN972PFAviation Capital Partners LLC · Camden, DEN99WJBgd&S Capital Holdings LLC · Dunedin, FLN9LVMike Lima LLC · Los Angeles, CA
Back to Raytheon 390