OpenAirDocs.org
AD 87-18-06 R1

Registered aircraft · 6,238

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:87-18-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-18-06-R1')
  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.

N6686XCoughlin James G · Naples, FLBuilt 1979 · S/N E-1616N66876Mcmarlin Richard C · Santa Fe, NMBuilt 1979 · S/N D-10316N66878Cool Blue Air LLC · Wilmington, DEBuilt 1979 · S/N TH-1100N6687DVolare Flight Service LLC · Pine Village, INBuilt 1983 · S/N EA-365N66885Turn Key Construction Services Inc · Lincoln, CAS/N EA-48N6688EHill Daniel DBA · Grove, OKBuilt 1979 · S/N D-10319N6688JQuesnel Robert Todd · Tomball, TXBuilt 1979 · S/N D-10299N6688UHotel Lima LLC · Oro Valley, AZBuilt 1980 · S/N D-10320N6688YHolt Kyle · Cottontown, TNBuilt 1979 · S/N EA-47N66896Diesbach Benjamin · Cincinnati, OHBuilt 1979 · S/N E-1623N6689JAce Technical Services LLC · Hernando, MSBuilt 1979 · S/N D-10321N6689NMoore Christopher J · Mebane, NCBuilt 1979 · S/N E-1622N668DESteele Kevin · Phoenix, AZBuilt 1983 · S/N EA363N668JGCapps Steven M · Mount Pleasant, TXBuilt 1999 · S/N E3266N668ZSDrumwright Gerald L · Ormond Beach, FLBuilt 1979 · S/N D-10258N66907Flynn Curtis J · Granbury, TXBuilt 1979 · S/N D-10322N6690GKey Lime Real Estate Inc · Lutz, FLBuilt 1979 · S/N E-1625N6690YThree Green LLC · Towanda, KSBuilt 1979 · S/N E-1627N66913Mp Air LLC · Stonewall, LABuilt 1979 · S/N E-1631N66916Technet Aviation LLC · Charlotte, MIS/N D-10327N66918Lbc1 LLC · Mount Olive, NCBuilt 1980 · S/N TH-1104N66919Gta Air Inc · Addison, TXBuilt 1979 · S/N E-1634N66928International Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N E-1628N6692RToga LLC · Scottsdale, AZBuilt 1980 · S/N EA-55N66932Worstell Kris D · Gordonville, TXBuilt 1979 · S/N E-1630N6695DExtrusions Inc · Fort Scott, KSBuilt 1980 · S/N E-1657N6695HMegan Anderson Nursing Services Inc · Yucaipa, CABuilt 1980 · S/N D-10343N6695NJosselyn David A · Riverside, CABuilt 1979 · S/N CE-895N6696DMayfly Aviation LLC · Quincy, FLBuilt 1980 · S/N E-1636N6696WClift William R II · Princeton, KYBuilt 1980 · S/N D-10329N6696YAlcri Inc · Lewes, DES/N E-1639N6696ZMonahans Affordable Homes LLC · Monahans, TXBuilt 1980 · S/N EA-56N669RPFanning William J · Dallas, TXBuilt 1979 · S/N E-1618N66ABCallis Jerrod G · California, KYBuilt 1969 · S/N CE-292N66AFSalmon Steven B · Liberty, MOBuilt 1980 · S/N TH1132N66HBSawtooth Travel Solutions LLC · Twin Falls, IDBuilt 1976 · S/N E-888N66JLLucia Joanne · Agawam, MABuilt 1975 · S/N E-711N66KDEnalp Investments LLC · Metairie, LABuilt 2003 · S/N E-3505N66KWPeavy Michael J Trustee · Chico, CAS/N CE-948N66LAAviary LLC · Greer, SCBuilt 1987 · S/N E-2394N66LCBusiness Jet Consultants LLC · Derby, KSBuilt 1977 · S/N E-1050N66LHLane Law Firm Pc · Greenwood Village, COBuilt 1981 · S/N EA-261N66VBButschky Jeffrey · Baldwin, MDBuilt 1978 · S/N CE-830N66WCWeiner Ronald I · Jackson, TNBuilt 1978 · S/N D-10199N66WZBowing Vending Co Inc · Louisville, TNBuilt 1980 · S/N TJ-321N6709QClear Blue Marketing Inc · Reno, NVBuilt 1983 · S/N EA-368N670GCFrauenhoff Frank · Manhattan, NVBuilt 1973 · S/N TH-359N671BBe-A36 Inc Owner Trustee · Wilmington, DEBuilt 2001 · S/N E-3409N671TCBraunstein Robert S · Seattle, WABuilt 2001 · S/N EA-671N67224Vx Inc · Burbank, CABuilt 1983 · S/N EA-370
Back to AD 87-18-06 R1