Registered aircraft · 18,496

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

N11XMWesley F Walker · Rock Hill, SCBuilt 1999 · S/N E-3225 N11YESky West Aviation Inc Trustee · Albuquerque, NMBuilt 1995 · S/N 29-0038 N11ZTQualitair LLC Trustee · MichelstadtBuilt 1987 · S/N CE-1108 N1203GWestern Pilot Service Inc · Phoenix, AZBuilt 1975 · S/N 414-0649 N1203NBracy Rodney E · Middleville, MIBuilt 1972 · S/N 12046 N1203WPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1980 · S/N 310R-2106 N1204FMoroney Aviation LLC · Chugiak, AKBuilt 1975 · S/N 18502767 N1206FHarrah Daniel R · Juneau, AKBuilt 1975 · S/N 18502769 N1206NCapital Group Inc · Garden City, IDBuilt 1985 · S/N 421C1805 N1207C3 Rs Incorporated · Perry Hall, MDBuilt 2003 · S/N 0455 N1208FYukon Air Service Inc · Fairbanks, AKBuilt 1975 · S/N 18502771 N120BCHunyadi James W · Toledo, OHBuilt 1979 · S/N P21000404 N120DBB & I Leasing LLC · Berryville, VABuilt 1978 · S/N E1276 N120HAAstley Mark C · Wayne, NJBuilt 1977 · S/N 340A0295 N120JHC&C Cessna LLC · Baltimore, MDBuilt 1977 · S/N U20603636 N120MPHall William M · Encinitas, CABuilt 1979 · S/N D-10248 N120PCHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0079 N120WPHentschel Ernest · Galloway, NJBuilt 2005 · S/N 1630 N1211FGarner Greg A · Renton, WABuilt 1975 · S/N 18502774 N1212GNickeson Family LLC · Maquoketa, IABuilt 1988 · S/N E-2418 N1214G9791m LLC · Tacoma, WABuilt 1975 · S/N 414-0652 N1215MBieber Dale E · Coralville, IABuilt 1977 · S/N 21061924 N1215TShepphird John C · Reno, NVBuilt 1966 · S/N TE-102 N1216GNeel Aviation LLC · Lakeland, FLS/N 414-0653 N1216NDodson International Parts Inc · Rantoul, KSBuilt 2003 · S/N 0549 N1217FUnited States Department Of Interior · Boise, IDBuilt 1975 · S/N 18502779 N121AFEway William · Jupiter, FLBuilt 1981 · S/N TH-1254 N121AMEastern Stearman Inc Trustee · Leesburg, VAS/N CE-1126 N121BDKorn Air LLC · Fort Lauderdale, FLS/N 414A0297 N121BEKrdm LLC · Fallon, NVS/N D-7920 N121BKSeabee Training Corp · Birmingham, ALBuilt 1977 · S/N 310R0893 N121BLOlson Brian D · Las Vegas, NVBuilt 1982 · S/N TJ-413 N121BRSmith Tad E · Colorado Springs, COS/N 1697 N121CBClark Andrew R · Woodside, CABuilt 1976 · S/N 340A0087 N121CEAdvanced Flight Instruction LLC · Greenwood, DEBuilt 1974 · S/N 21060503 N121DSongbird Aviation LLC · Larkspur, CABuilt 1984 · S/N CE-1033 N121EDLarry K Brown · Round Rock, TXBuilt 1979 · S/N 80-30969 N121EESheldon Air Service LLC · Anchorage, AKBuilt 1979 · S/N 18503765 N121GAWood David J · Lincolnshire, ILBuilt 2005 · S/N 1443 N121GJ424 Ventures LLC · Saint Petersburg, FLBuilt 1976 · S/N TJ-62 N121GPTaft Diversified LLC · Springfield, ILBuilt 1985 · S/N 46-8508086 N121HCUsaircraft Inc · Newark, DEBuilt 2002 · S/N 0277 N121HTSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 0794 N121JRKlotz Geoffrey B · Moor Park, CABuilt 1977 · S/N 21061726 N121LLWild Blue Air LLC · Homer, AKBuilt 1977 · S/N U20603756 N121PAN121pa LLC · Kalispell, MTBuilt 2019 · S/N 32-0010 N121PEEggers Phillip S · Denton, TXBuilt 1983 · S/N EA-388 N121RJCessna 121 Rj LLC · Terra Bella, CABuilt 1972 · S/N 21059735 N121RPJohn A Rossi Inc · West Chester, PABuilt 1998 · S/N 29-0141 N121RWArbuckle Air LLC · Kansas City, MOBuilt 1970 · S/N CE-296

Back to AD 86-13-04 R3