OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,497

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
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.

N411MLRosner Louis M · Port Orange, FLBuilt 1972 · S/N E-308N411MZSongbird Air LLC · Lakewood, COBuilt 1980 · S/N 421C1002N411STwin Adventures LLC · Cincinnati, OHBuilt 1972 · S/N 340-0099N411SMKonkel Bernard · Kalispell, MTBuilt 1978 · S/N 310R1404N411TBLewis Nathan · North Plains, ORS/N 421B0481N411TTRambod Marc · Taos Ski Valley, NMBuilt 1975 · S/N 21060861N411TXGilbert Ivory M · Bonita Springs, FLBuilt 2005 · S/N 29-0410N411VTvc Aviation Inc · Lebanon, OHBuilt 1973 · S/N 340-0250N411VGMontala Investments LLC · Montgomery, ALBuilt 1981 · S/N 414A0675N411VTFletcher Holdings Of Nc LLC · Winston Salem, NCBuilt 2002 · S/N 0393N411WTSeaguard Technologies Inc · Houston, TXS/N E-3958N411ZJkdj LLC · Tyler, TXBuilt 1973 · S/N 421B0482N4121XSignature Remodeling LLC · Boonville, MOBuilt 1975 · S/N E-651N4122KWargo Michael S · Colorado Springs, COBuilt 1998 · S/N 3246106N4123TRace Dean · Chicken, AKBuilt 1966 · S/N 320D0023N4124SAvondale Aviation LLC · Park Ridge, ILBuilt 1975 · S/N E-653N4124WGeaux Automotive Advertising LLC · La Place, LABuilt 2000 · S/N TH-1943N4125GSeeding Operations And Atmospheric Research (Soar) · San Angelo, TXBuilt 1977 · S/N 340A0297N4127SKrall Jeff P · Mitchell, SDBuilt 1975 · S/N D-9738N412AVMatthews Air LLC · Powhatan, VABuilt 2015 · S/N E-4073N412BPMission Hardward Ltd Co · Savannah, GABuilt 1983 · S/N T30300213N412CAAirswiss Inc · Wilmington, DES/N 402C0005N412DPickens Ray T · Pleasanton, TXBuilt 1974 · S/N TH-464N412DJStringfield Lisa P · Los Alamos, NMBuilt 2005 · S/N 1433N412GHHavemeier Gregory Wiliam · Marco Island, FLBuilt 2019 · S/N TH2518N412JLBills Brian J · Corry, PABuilt 1966 · S/N TE-38N412TRoberts Gregory · Scottsdale, AZBuilt 1972 · S/N 21059558N412TKBaerresen Drake A · Corona, CAS/N 0552N412YMurrieta Humberto · San Antonio, TXS/N D-9292N4130SYakish S Dale · Wexford, PABuilt 1975 · S/N TH-612N4130TSteven J Leavitt · Avondale, AZS/N 320D0030N4133BMachinerywatch.Com Inc · Louisa, VABuilt 1975 · S/N 75-30795N4134SQualitair LLC Trustee · MichelstadtBuilt 1975 · S/N TJ-18N4135BBice Christopher S · Summerville, SCS/N 76-30808N4135SRazzyfish Inc · Colton, CABuilt 1975 · S/N D-9787N4135TNehls Chevrolet Olds Cadillac · Marshall, TXBuilt 1965 · S/N 320D0035N4137BWalker James D · Grapevine, TXBuilt 1974 · S/N 75-30738N4137CN4137c Inc · Redwood City, CABuilt 1979 · S/N 21063566N4138TLindquist Holdings LLC · Noblesville, INBuilt 1965 · S/N 320D0038N413BMLee Aviation LLC · Sheridan, ARBuilt 1977 · S/N 414A0004N413EM413em LLC · Columbia, ILBuilt 2005 · S/N 29-0388N413GKKgc Holdings Ltd · Newark, TXBuilt 1973 · S/N D-9450N413KGEagle Mountain International Church Inc · Newark, TXBuilt 1976 · S/N TE-1076N413KJHuber Jeffrey C · Sidney, OHBuilt 1980 · S/N D-10307N413KSMatteo Properties · Wickliffe, OHS/N 333N413LBOficinas De Carolina Inc · San Juan, PRBuilt 1981 · S/N 18504200N413MBrookway Investments LLC · Brookhaven, MSBuilt 1977 · S/N E1151N413PTag Aviation LLC · Larwill, INBuilt 2004 · S/N 1073N413PMJl Bonanza LLC · Keller, TXBuilt 2011 · S/N E-3968N413SLMilestone Plane LLC · Wilmington, DEBuilt 1988 · S/N CE-1289
Back to AD 86-13-04 R3