Registered aircraft · 88

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

N10EAEagle Air Transport Inc · Ottawa, ILS/N 199 N123FXFreefall Express · Gardiner, NYBuilt 1969 · S/N 200 N141ZUsda Forest Service · Boise, IDBuilt 1984 · S/N 803 N142SAMonarch Enterprises Inc · Kirkland, WABuilt 1969 · S/N 241 N143SATwin Otter International Ltd · Las Vegas, NVBuilt 1978 · S/N 591 N143ZUsda Forest Service Fire & Aviation · Boise, IDBuilt 1974 · S/N 437 N148SAZuni LLC · Kirkland, WAS/N 409 N153KDMec International Trading LLC · Mission, TXBuilt 1968 · S/N 153 N167WCWashington Corporations Inc DBA · Missoula, MTS/N 343 N169BADesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 1967 · S/N 103 N171GCRigidworks LLC · Anaconda, MTBuilt 1974 · S/N 406 N177GCDiamond Bar LLC · Kirkland, WABuilt 1969 · S/N 263 N178GCRigidworks LLC · Anaconda, MTBuilt 1980 · S/N 697 N186ALAlm Holdings Delaware LLC · Wilmington, DES/N 186 N189GCCortez Fisher LLC · Kirkland, WABuilt 1981 · S/N 772 N190GCMonarch Enterprises Inc · Kirkland, WABuilt 1970 · S/N 285 N204BDKavalair LLC Series G · Marion, MTBuilt 1969 · S/N 204 N223ALWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N 223 N224SAIkhana Aircraft Holdings LLC · Murrieta, CABuilt 1969 · S/N 247 N225SATwin Otter International Ltd · Las Vegas, NVS/N 686 N227WWFayard Enterprises LLC · Wake Forest, NCBuilt 1966 · S/N 27 N228SAMonarch Enterprises Inc · Kirkland, WABuilt 1969 · S/N 253 N228YKDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 1969 · S/N 228 N229SATwin Otter International Ltd · Las Vegas, NVS/N 468 N241SADiamond Bar LLC · Kirkland, WABuilt 1977 · S/N 556 N301CLWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N 221 N321CYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1968 · S/N 211 N337MBDesert Sand Aircraft Leasing Co Inc · Rosharon, TXS/N 37 N344CSTransport Company LLC · Colorado Springs, COBuilt 1971 · S/N 334 N359ARTwin Otter International Ltd · Las Vegas, NVBuilt 1973 · S/N 359 N365ARTwin Otter International Ltd · Las Vegas, NVBuilt 1973 · S/N 365 N368SSSierra Aviation Holdings LLC · Colorado Springs, COS/N 368 N40269Freefall Express Inc · Gardiner, NYBuilt 1968 · S/N 152 N403MLDhc6-403 Equity LLC · Palm Beach, FLBuilt 1974 · S/N 403 N418AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 1977 · S/N 521 N434ARTwin Otter Support Services LLC · Las Vegas, NVBuilt 1974 · S/N 432 N450PPJ R S Sky Inc · Pound Ridge, NYBuilt 1975 · S/N 450 N469TSDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 1968 · S/N 149 N46RFUnited States Department Of Commerce · Lakeland, FLBuilt 1985 · S/N 824 N48RFUnited States Department Of Commerce · Lakeland, FLBuilt 1981 · S/N 740 N49SJUnited States Department Of Interior · Boise, IDBuilt 1974 · S/N 423 N504WJVantage Air Corp · Kalispell, MTBuilt 1976 · S/N 503 N511DHLandlocked Company LLC · Dover, DES/N 511 N512ARTwin Otter International Ltd · Las Vegas, NVBuilt 1967 · S/N 59 N515ARTwin Otter International Ltd · Las Vegas, NVBuilt 1976 · S/N 515 N537ARAvro Ltd · Las Vegas, NVBuilt 1977 · S/N 537 N562CPVantage Air Corp · Kalispell, MTBuilt 1977 · S/N 562 N56RFUnited States Department Of Commerce · Lakeland, FLBuilt 1982 · S/N 788 N576LLLandlocked Company LLC · Dover, DES/N 576 N57RFUnited States Department Of Commerce · Lakeland, FLBuilt 1981 · S/N 688

Back to AD 69-05-01 R2