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.

N4504SRegistered aircraftBuilt 1975 · S/N E-720N4505SGo Flyers LLC · Sudbury, MABuilt 1975 · S/N CE-596N4506SBaghs LLC · Fort Lauderdale, FLS/N D-9795N450JRNowell Borders Lp · Edinburg, TXBuilt 1975 · S/N TH-670N450THHk Air LLC · Byron, GABuilt 1981 · S/N TH-1298N450WSMatter Donald Chad Trustee · Friendswood, TXBuilt 1979 · S/N E-1552N450YRSmith John W Jr · Stamps, ARBuilt 1981 · S/N CE-978N4510MRcl Farms Leasing LLC · Bronwood, GAS/N TK-70N4513MLeopold Aero LLC · Wilmington, DEBuilt 1978 · S/N TE-1127N4515MCooper Steve O · Phoenix, AZBuilt 1978 · S/N CE-767N4515SHarris Aviation LLC · Texarkana, TXBuilt 1975 · S/N E-725N4516SConcepcion Carlos L · Pembroke Pines, FLBuilt 1975 · S/N TE-1057N4519SBlanck Greg J · Redwood City, CABuilt 1975 · S/N E-719N451MJRoost Leasing LLC · Sturgis, MIBuilt 1985 · S/N E-2246N451STrevathan Max Tyler · Dyersburg, TNBuilt 1977 · S/N E1200N451SBModleski Matthew · Noblesville, INBuilt 1978 · S/N TH-897N4523SLucky92 & Associates LLC · Reno, NVBuilt 1976 · S/N TE-1062N4524SKnox James P · Park Rapids, MNBuilt 1975 · S/N E-727N4527MF33 Air LLC · Selinsgrove, PABuilt 1978 · S/N CE-768N4528SMoore William W · Merritt Island, FLBuilt 1975 · S/N D-9799N4529MMetzler Aaron · Otis, COBuilt 1978 · S/N D-10115N4529SRegistration Pending · Frisco, TXRegistration pendingBuilt 1975 · S/N CE-600N452CWashington Derrick A · Louisville, KYBuilt 1999 · S/N E-3256N452SCBond Jeffrey B · Lebanon, MOBuilt 1975 · S/N D-9771N4532SElite Aviation Partners LLC · Blacklick, OHBuilt 1975 · S/N CE-598N4533SBolanos Nilson J · Fairview, NJBuilt 1975 · S/N CE-612N4534SMarmon Robert A · Merion Station, PABuilt 1975 · S/N E-743N453SAHts LLC · Hudsonville, MIBuilt 2002 · S/N E-3453N4540Mathis Mark L · Fremont, CABuilt 1971 · S/N E-299N4541MPerez Johnathan Daniel · Placerville, CABuilt 1978 · S/N E-1232N4545MSimplifly Aviation LLC · Elon, NCBuilt 1978 · S/N TH-914N4547MOxly Aviation LLC · Wilmington, DEBuilt 1978 · S/N TH-915N4547SLorentz Aviation LLC · Canadian, TXBuilt 1976 · S/N TJ-81N454JDickey Michael W · Fredericksburg, TXBuilt 1979 · S/N E-1571N4551SAak Enterprises LLC · Fayetteville, ARFirst renewal noticeBuilt 1976 · S/N CE-645N4556MPerry Richard H · Crossville, TNBuilt 1978 · S/N E-1234N4559MSky High Ventures LLC · Bartlett, TNS/N E-1235N455DSanders Tyler B · Yuma, AZBuilt 1989 · S/N CE-1408N455JRHinaa Hidaa LLC · Chino Valley, AZS/N EA-124N455PN455p LLC · Fulshear, TXBuilt 1999 · S/N E3276N455RBGh Enterprises Inc · Baton Rouge, LABuilt 1977 · S/N TE-1099N455SDJ&L Aviation LLC · Malta, NYS/N TJ-405N4560MPhillips William S · Normandy Park, WAFirst renewal noticeBuilt 1978 · S/N CE-770N4562MBbt Aviation LLC · Rapid City, SDBuilt 1978 · S/N E-1237N4563SMeyerhoff Scott G Trustee · Reno, NVBuilt 1975 · S/N CE-604N4565SGl Aviation LLC · Mcmurray, PABuilt 1975 · S/N E-736N4566MPalacios Luis A · El Paso, TXBuilt 1978 · S/N TJ-182N4566SWalters G David · Sarasota, FLBuilt 1975 · S/N D-9804N4568SYuma Desert Fliers LLC · Yuma, AZFirst renewal noticeBuilt 1975 · S/N CE-605N4569SMiles Lawrence W Jr · Sacramento, CABuilt 1975 · S/N E-745
Back to AD 87-18-06 R1