Skip to content

Registered aircraft · 6,916

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:97-01-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-01-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:97-01-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-01-R1')
  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, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:97-01-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-01-R1')
ORDER BY n_number

Run 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.

N5405PJohnson Sidney · Madison, MNBuilt 1958 · S/N 24-459 N5406DReardon Matthew J · Henderson, NVBuilt 1975 · S/N 347570142 N5406PDerksen Ronald E · Xenia, ILBuilt 1958 · S/N 24-460 N5408PZero Eight Papa LLC · Dublin, OHBuilt 1958 · S/N 24-462 N5409PReinaudi Gael · New York, NYBuilt 1958 · S/N 24-463 N540PULeo S Anton · Aliso Viejo, CABuilt 2003 · S/N 2844096 N5411FMack Robert A · Brighton, COBuilt 1976 · S/N 32R-7780003 N5411PLarson Andrea S · Wasilla, AKBuilt 1958 · S/N 24-465 N5417PMoran Patrick D · Pleasanton, CABuilt 1958 · S/N 24-471 N5419PTrease Marvin R · Elwood, NEBuilt 1958 · S/N 24-473 N541ACCubillos Fernando Jose · Miami Beach, FLBuilt 1975 · S/N 347570129 N541HFOpen Flight Plan LLC · Decatur, GABuilt 1973 · S/N 28R-7335335 N541PUEquipment Maintenance Specialists LLC · Auxvasse, MOBuilt 2003 · S/N 2844097 N5423FSkyfusion II LLC · Atlanta, GAS/N 34-7770018 N5423PPapp Frank J · Fort Mohave, AZBuilt 1959 · S/N 24-477 N5424PHerreid William L Jr · Prairie Du Chien, WIBuilt 1958 · S/N 24-478 N5426PTromble Tim L · Story, WYBuilt 1958 · S/N 24-480 N5429PSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1958 · S/N 24-483 N542HFPars Avn Corp · Wilmington, DEBuilt 1974 · S/N 28R-7435310 N542JPGrauer Keaton · Marysville, KSBuilt 1968 · S/N 28R-30772 N542PUNewbridge Unlimited LLC · Sunny Isles Beach, FLBuilt 2003 · S/N 2844099 N5430PHeight David B · El Prado, NMBuilt 1958 · S/N 24-484 N5432FHornish Thomas L · Malinta, OHBuilt 1976 · S/N 32R-7780007 N5433FNh86 Bumblebee LLC · Henniker, NHBuilt 1976 · S/N 32R-7780008 N5434PDavison Matt E · Pueblo, COBuilt 1958 · S/N 24-488 N5437PDeplorable Air LLC · Lakeland, FLBuilt 1958 · S/N 24-263 N54384Above All Aviation Inc · Goleta, CABuilt 1973 · S/N 34-7450059 N54391Still Water Security Co LLC · Meriden, CTBuilt 1973 · S/N 28R-7435094 N54398Lashback Communications LLC · Farwell, MIBuilt 1973 · S/N 28R-7435097 N543JDSybesma Troy S · Claremont, MNBuilt 1960 · S/N 24-1785 N543POracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 28R-7435227 N543PUByc Trucking Services LLC DBA · Norco, CABuilt 2003 · S/N 2844100 N5440PWurlitzer Lindsay Pabst Trustee · Healdsburg, CABuilt 1958 · S/N 24-494 N54412Flight Time Builders Inc · Memphis, TNBuilt 1973 · S/N 28R-7435098 N54414Panjab Aviation Inc · Las Vegas, NVS/N 28R-7435101 N5441PBellah Mark E · Alva, OKBuilt 1958 · S/N 24-495 N5442FMcclary James Emmett Jr · Athens, ALBuilt 1976 · S/N 32R-7780010 N5442PMountain Air Restoration · Bend, ORBuilt 1958 · S/N 24-496 N5442TMckinney Christopher W · Queensbury, NYBuilt 1972 · S/N 28R-7235232 N5443PSbroglia Gregory A · Farmington Hills, MIBuilt 1958 · S/N 24-497 N5446PRegistration Pending · Cypress, TXRegistration pendingBuilt 1958 · S/N 24-501 N54473Gomez Julian E · Palo Alto, CAFirst renewal noticeBuilt 1973 · S/N 28R-7435110 N54485Schrock Paul · Mooresville, NCBuilt 1973 · S/N 28R-7435112 N5448PStarfire Aviation LLC · Conyers, GABuilt 1958 · S/N 24-503 N544BPLopez Federico Ruiz · Hollywood, FLS/N 34-7250344 N5450PRegistration Pending · Sun Lakes, AZRegistration pendingBuilt 1958 · S/N 24-505 N5451FVirginia Aviators LLC · Sterling, VABuilt 1976 · S/N 32R-7780011 N5451PWilliams Andrew B · Mineral Wells, TXS/N 24-506 N5452PLewis Nathan W · Vale, ORBuilt 1958 · S/N 24-508 N5453PNoel Andrew F Jr · Morton, WABuilt 1958 · S/N 24-509

Back to AD 97-01-01 R1