Registered aircraft · 26

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

N102RRMoyer Aviation Ll C · Katy, TXS/N 1477-5 N114MNSutton Aircraft Salvage LLC · Palmer, AKBuilt 1965 · S/N 1553-107 N165KMowbray Aviation Inc · Reno, NVBuilt 1963 · S/N 680F-1252-126 N198JWGarrison William E · Nickerson, KSBuilt 1962 · S/N 680F-1132-75 N199WMJetstream Ltd · Powell, OHBuilt 1964 · S/N 1406-59 N2755BBoyce Aviation Inc · New Port Richey, FLBuilt 1965 · S/N 1541-105 N2828SSuburban Air Express Inc · Fairbanks, AKBuilt 1963 · S/N 1329-14 N290MPSuburban Air Express Inc · Fairbanks, AKBuilt 1965 · S/N 1535-104 N309VSSutton Aircraft Salvage LLC · Palmer, AKBuilt 1967 · S/N 1659-128 N385CGOwensboro Warehouse Leasing LLC · Owensboro, KYBuilt 1965 · S/N 1495-14 N401MGLeff William J · Dayton, OHBuilt 1965 · S/N 1527-29 N411WRForbes Greg · Placerville, CAS/N 1505-19 N5035ESuburban Air Express Inc · Fairbanks, AKBuilt 1968 · S/N 1764-147 N572TNShelton Paul K · Flushing, NYS/N 1360-38 N6253XMoudy James D · Fairhope, ALBuilt 1961 · S/N 680F-1089-67 N6272XPrairie Aviation Museum Inc · Bloomington, ILS/N 680F-1159-83 N630TAN630ta Corp · Miami, FLBuilt 1962 · S/N 1214-112 N6350UWeatherbird Ltd · New York, NYRegistration revokedBuilt 1965 · S/N 1431-150 N680FTTwin Aviation LLC · Natchitoches, LAS/N 680F-1120-73 N680PLDw Educational Research Inc · Fowler, CABuilt 1961 · S/N 680F-969-27 N680RRNizex Inc · Jackson, GABuilt 1963 · S/N 1361-139 N742WAirborne Holdings Inc · Midlothian, TXBuilt 1966 · S/N 680FL-1650 N800TTwin Aviation LLC · Coushatta, LABuilt 1960 · S/N 98633 N9011NSutton Aircraft Salvage LLC · Palmer, AKBuilt 1969 · S/N 1836-153 N965ARRubio Brunet Pedro Angel · Mulberry, FLS/N 1195-100 N991BDAfk Corp · Ripon, WIS/N 1483-8

Back to AD 62-05-01