Registered aircraft · 18,495

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.

N890RDSengle Gregory R · Amherst, MAFirst renewal noticeBuilt 1996 · S/N 29-0089 N890WBelcher Timothy A · Liberty, KSBuilt 1964 · S/N D-7563 N8911XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1998 · S/N E-3166 N8917MAero Flite Del Inc · Felton, DEBuilt 1964 · S/N D-7322 N8917UBashaw Trenton C · Newport Beach, CABuilt 1965 · S/N D-7910 N8919UCrosswell Joe D · Springtown, TXBuilt 1965 · S/N CD-943 N891ACWelshinger Douglas · Ozark, MOBuilt 2005 · S/N ES-186 N8921ULucy Donald E III · Newbury Park, CABuilt 1965 · S/N D-7911 N8922UN8922u LLC · Twin Falls, IDS/N D-7913 N8923UCarolina Insulation & Foam Inc · Asheboro, NCBuilt 1965 · S/N D-7917 N8924MTre Aviation Corp · Wilmington, DEBuilt 1964 · S/N D-7337 N892JHMaitland Property Management LLC · Plano, TXBuilt 2000 · S/N E-3323 N892WWWasserburger John C · Collierville, TNBuilt 1992 · S/N CE-1694 N8930NReprop LLC 310 Series · Wilmington, DEBuilt 1977 · S/N 310R0986 N8932US35 Aviation LLC · Lakeland, FLBuilt 1965 · S/N D-7921 N8933Walthers John P · Mequon, WIBuilt 1989 · S/N CE-1384 N8935MGoldberg Alan N · Point Clear, ALBuilt 1972 · S/N 21059635 N8939USiegfried Robert W II · Downers Grove, ILBuilt 1965 · S/N D-7924 N893BWLahbak Enterprises LLC · Hilton Head Island, SCBuilt 1980 · S/N P21000498 N8941GHawks Eye View LLC · Roanoke, VAS/N 340A0327 N8942UConner Ernest A III · Dallas, TXBuilt 1965 · S/N D-7933 N8944DFerguson Parker W · Norman, OKBuilt 1966 · S/N D-8285 N8944MEngland Neil Dean Jr Trustee · Watsonville, CABuilt 1965 · S/N D-7940 N8945UPoeppelman Philip W · Versailles, OHBuilt 1965 · S/N D-7923 N8946UEilers John D · Royal City, WABuilt 1965 · S/N D-7928 N8948UClarke Cheryl A · Oakley, CABuilt 1965 · S/N D-7945 N894AHAerospace Asset Holdings LLC · Wilmington, DEBuilt 1977 · S/N U20604061 N894JGMeasured Approach LLC · Wooster, OHBuilt 1972 · S/N 340-0098 N8951MZimmerman Bruce M · Crittenden, KYBuilt 1964 · S/N D-7338 N8955ZSimmons Louis Crispin · Williamsburg, VABuilt 1999 · S/N TH-1897 N895ACTejas Cavu LLC · Wilmington, DEBuilt 1978 · S/N 340A0558 N895AHAerospace Asset Holdings LLC · Wilmington, DEBuilt 1981 · S/N U20606419 N895CDCarfinder LLC · Huntington Station, NYBuilt 2003 · S/N 0577 N895SLOcca Aviation LLC · Beaumont, TXBuilt 2005 · S/N 1323 N8967GHill Cannon E · West Richland, WAFirst renewal noticeS/N 18260507 N896SASwitlik Aviation Maintenance Inc · Fort Myers, FLBuilt 1970 · S/N 21059358 N897BDHartmann Christopherd · Houston, TXBuilt 2014 · S/N E-4049 N897TRegistered aircraftBuilt 1972 · S/N D-9354 N897TMLow Approach Only LLC · Wilmington, DEBuilt 1965 · S/N D-7962 N8981MPeter N Steinmetz Trustee · Tempe, AZBuilt 1964 · S/N D-7339 N8982MSharman Paul D · Carefree, AZBuilt 1964 · S/N D-7310 N8986M170kts LLC · Novato, CABuilt 1964 · S/N D-7313 N898BHPompa Oliver · Tuscon, AZBuilt 1980 · S/N 21064108 N898DMMeis David Bradley · Belmont, NCS/N E-3216 N898EPMarcy Michael S · Farmington, NMBuilt 1973 · S/N 421B0429 N898JBSalesapproach Inc · Marlborough, MABuilt 1975 · S/N E-704 N898JPK Supply Company Inc · Horton, ALBuilt 2005 · S/N 1308 N898LMMlm Aviation LLC · Mars Hill, NCBuilt 1977 · S/N 340A0254 N898PJBaucum Jeffrey P · Sequim, WABuilt 1997 · S/N 29-0109 N898WPTriple B Aviation Inc · Idabel, OKBuilt 1990 · S/N CE-1513

Back to AD 86-13-04 R3