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:80-13-11-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:80-13-11-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:80-13-11-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:80-13-11-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:80-13-11-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:80-13-11-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.

N60619Ssc International Inc · Las Vegas, NVS/N 210 N611EMLandlocked Company LLC · Dover, DES/N 611 N614ARTwin Otter International Ltd · Las Vegas, NVBuilt 1979 · S/N 614 N615ARTwin Otter International Ltd · Las Vegas, NVBuilt 1979 · S/N 615 N633ARTwin Otter Support Services LLC · Las Vegas, NVBuilt 1979 · S/N 633 N647MCCollier Mosquito Control District · Naples, FLBuilt 1967 · S/N 087 N660FBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 472 N660FKAviation Management Sales LLC · Fort Pierce, FLS/N 386 N660FMAviation Management Sales LLC · Fort Pierce, FLS/N 484 N660FNAviation Management Sales LLC · Fort Pierce, FLS/N 443 N660FYAviation Management Sales LLC · Fort Pierce, FLS/N 383 N662AVBerry Aviation Inc · San Marcos, TXBuilt 1980 · S/N 662 N669JWKapowsin Air Sports Ltd · Shelton, WABuilt 1968 · S/N 088 N675BABerry Aviation Inc · San Marcos, TXBuilt 1980 · S/N 675 N690MFDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 1968 · S/N 121 N692ARN692ar LLC · Kalispell, MTBuilt 1980 · S/N 692 N692DADirect Action Aviation LLC · Reno, NVBuilt 1968 · S/N 151 N708PVPm Leasing Inc · Perris, CABuilt 1976 · S/N 489 N70EAEagle Air Transport · Ottawa, ILS/N 139 N723ARTwin Otter International Ltd · Las Vegas, NVBuilt 1980 · S/N 723 N743LLLandlocked Company LLC · Dover, DES/N 743 N74GCDiamond Bar LLC · Kirkland, WABuilt 1977 · S/N 559 N753AFTwin Otter International Ltd · Las Vegas, NVS/N 206 N7MCSt Tammany Parish Mosquito Abatement District · Slidell, LABuilt 1967 · S/N 40 N806RTIkhana Aircraft Holdings LLC · Murrieta, CAS/N 009 N807USRegistration Pending · Miami, FLRegistration pendingS/N 807 N808PCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 77 N808RTIkhana Aircraft Holdings LLC · Murrieta, CABuilt 1976 · S/N 499 N809LLLandlocked Company LLC · Dover, DES/N 809 N814BCRegistered aircraftS/N 548 N821ARFairey Ltd · Las Vegas, NVBuilt 1974 · S/N 421 N823XTransport Services LLC · Birmingham, ALS/N 823 N826XTransport Services LLC · Birmingham, ALBuilt 1985 · S/N 826 N82LHAirborne Support Group LLC · Marion, MTBuilt 1969 · S/N 208 N905RTOregon Department Of Forestry · Salem, ORBuilt 1970 · S/N 297 N9295Bank Of Utah Trustee · Salt Lake City, UTBuilt 1977 · S/N 532 N92FEWarren Transportation LLC · Dallas, TXBuilt 1969 · S/N 242 N94ARTwin Otter International Ltd · Las Vegas, NVBuilt 1973 · S/N 388

Back to AD 80-13-11 R2