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.

N224DPBlue And Gold Aviation LLC · Marietta, OHBuilt 1991 · S/N E-2599N224DRN224dr LLC · Morristown, NJBuilt 2000 · S/N EA-660N224SHWhitney Bryan · Lake Havasu City, AZBuilt 1970 · S/N D-9152N2251QSabo John W · Spicewood, TXBuilt 1997 · S/N EA-604N2255NMalard Darren L · Bismarck, NDBuilt 1974 · S/N D-9580N225CRQualitair LLC Trustee · MichelstadtBuilt 1982 · S/N EA 317N225JWTalbot Larry · Lakewood Ranch, FLBuilt 2001 · S/N E-3418N225PSalem Aviation LLC · Winston Salem, NCBuilt 1997 · S/N EA-608N225TAN225ta LLC · Loganville, GABuilt 1970 · S/N TH-64N22604Tarten Air Inc · Smiths Creek, MIBuilt 1978 · S/N E-1287N2261LGaf Skyborne Aviation Ventures LLC · El Dorado Hills, CABuilt 1979 · S/N E-1535N2264LWoolum Stephanie · Varney, WVBuilt 1976 · S/N TH-771N2265LNeilsen Lorenzo I · Wilmington, NCS/N D-9939N226MASum Beech Inc · Knoxville, TNS/N CE-641N226SCJohnson Lansworth P · Jackson, WYBuilt 1984 · S/N EA-406N2270LBas Part Sales LLC · Greeley, COBuilt 1976 · S/N E-922N2271LBurchinal Skyler · Brookston, TXS/N TJ-71N2272LBaum Jeffrey · Sheridan, WYBuilt 1976 · S/N D-9944N2273LLtt Flights LLC · Clinton, MOFirst renewal noticeBuilt 1976 · S/N E-925N2275LN2275l LLC · Ball Ground, GABuilt 1976 · S/N D-9945N2276CLeading Edge Consulting LLC · Mitchell, SDBuilt 1976 · S/N CE672N227BRSchoo Michael J Trustee · Ridgway, COBuilt 1977 · S/N TK-31N227MWWatson Michael Timothy · Granbury, TXBuilt 1974 · S/N D-9682N2280BDream Flight Aviation LLC · New Fairfield, CTBuilt 1982 · S/N TH-1344N2283LMoser Jerald L · Tucson, AZS/N D-9948N2284LUpchurch David E · Bahama, NCBuilt 1976 · S/N E-929N2285LN2285l Aviation LLC · Robbinsville, NJBuilt 1976 · S/N E-930N2286LBaty John W · Ames, IABuilt 1976 · S/N CE-675N2288LCherryhill Aviation Inc · Freetown, INS/N TJ-70N2289ERegistered aircraftBuilt 1997 · S/N TH-1821N2289LOne R Aviation LLC · Newington, CTBuilt 1976 · S/N D-9949N228ABLuke Stephen J Trustee · Middleboro, MABuilt 1991 · S/N E-2655N228CCutter Southwest Aircraft Sales LLC · Phoenix, AZBuilt 1985 · S/N CE-1059N228CKN-Flight LLC · Kenedy, TXBuilt 2003 · S/N E-3487N228CLArdillo Nick S · Dallas, TXBuilt 1984 · S/N E-2168N228DMStone Michael · Payson, AZBuilt 1991 · S/N E-2660N22917Paducah Midstream Grocery Inc · Paducah, KYBuilt 1978 · S/N TE-1118N2292LGenzoli Steven · Hughson, CABuilt 1976 · S/N D-9947N2293LLemac Aviation LLC · Mesa, AZBuilt 1976 · S/N E-971N2294LFlying Friends LLC · Shavano Park, TXBuilt 1976 · S/N CE-676N2296DBonanza Flyers L3c · Murray, UTBuilt 1977 · S/N D-9997N2296LDel Air Inc · Wilmington, DEFirst renewal noticeBuilt 1976 · S/N E-932N2298EUberoy Pawan · Pleasanton, CABuilt 1997 · S/N E3138N2299LSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N CE-677N229TARemes Stephen · Northfield, MNBuilt 1978 · S/N TH-887N22AGMavridoglou Theo A · Brandon, MSBuilt 1973 · S/N D-9499N22CCLegacy Air LLC · Oklahoma City, OKBuilt 1984 · S/N TJ-471N22HGFreeno Joseph · Upland, CAS/N CE-1102N22TYCygnus9 LLC · Fayetteville, NCBuilt 1997 · S/N TH-1826N22VHSchiltz David A · Ankeny, IABuilt 1973 · S/N D-9458
Back to AD 87-18-06 R1