Registered aircraft · 126

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:2000-08-52') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-08-52') 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:2000-08-52')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-08-52')
  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:2000-08-52')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-08-52')
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.

N689HHillcrest Aircraft Co Inc · Lewiston, IDBuilt 1979 · S/N 30289 N68ECCopter Lease LLC Trustee · Albuquerque, NMBuilt 1968 · S/N 30008 N714BHHelistream Inc · Kalispell, MTBuilt 1979 · S/N 30953 N750DMTradehawk International LLC · Ramona, CAS/N 66-16114 N775BBCopter Lease LLC Trustee · Albuquerque, NMBuilt 1977 · S/N 30252 N8056TAdvanced Aviation Technology Enterprises Inc · Arcadia, FLFirst renewal noticeS/N 30501(SW)N808MLCopter Lease LLC Trustee · Albuquerque, NMBuilt 1966 · S/N 2043 N811KARogers Helicopters Inc · Fresno, CABuilt 1974 · S/N 30656 N815SSHilcorp Equipment LLC · Anchorage, AKBuilt 1979 · S/N 30950 N816SSHilcorp Equipment LLC · Anchorage, AKBuilt 1982 · S/N 31209 N82WWeyerhaeuser Nr Co · Eugene, ORBuilt 1981 · S/N 31177 N82WPSalt River Pro Agr Imp & Power Dist · Phoenix, AZBuilt 1980 · S/N 31128 N83230Temsco Helicopters Inc · Ketchikan, AKBuilt 1973 · S/N 30560 N8373HEleven 11 Ventures LLC · Helena, MTS/N 5631 N853QAHeli-Consignment Inc · Chicago, ILBuilt 1977 · S/N 30815 N87LHHill Lawrence E · Marion, MTBuilt 1971 · S/N 30087 N88HVAppomattox Aviation LLC · Santa Fe, NMBuilt 1980 · S/N 31118 N90057Helibase Inc · Cape TownS/N 30500(SW)N911HWRogers Helicopters Inc · Fresno, CABuilt 1980 · S/N 31101 N911KWRogers Helicopters Inc · Fresno, CABuilt 1973 · S/N 30592 N911VRRogers Helicopters Inc · Fresno, CABuilt 1980 · S/N 30998 N9122ZIntermountain Helicopter Inc · Sonora, CABuilt 1975 · S/N 30716 N922VSVertol Systems Co Inc · Destin, FLS/N 30922 N933CHCoastal Helicopters LLC · La Verne, CABuilt 1969 · S/N 30062 N966XBh212966 LLC · Crestline, CABuilt 1979 · S/N 30966 N99WLCorpat Inc · Missoula, MTBuilt 1970 · S/N 30086

Back to AD 2000-08-52