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.

N843AHDynamics Flight LLC · Milwaukee, WIBuilt 1984 · S/N E2190N843CMLamar Lending LLC · League City, TXBuilt 1975 · S/N E-754N843TClifford Brent N · Lubbock, TXBuilt 1973 · S/N D-9482N844BEJoe Koch Construction Inc · Youngstown, OHBuilt 1984 · S/N E2199N844CSSchmidt Clifford W · Jackson, MIBuilt 1970 · S/N D-9247N844HSanker Frank Trustee · Keller, TXBuilt 1991 · S/N CE-1623N845DBPierce Ryan · Longview, TXBuilt 1982 · S/N E-2044N845JBAnna Aviation LLC · Gravois Mills, MOS/N CE-719N847DDF33a Holdings LLC · Woodbridge, VABuilt 1989 · S/N E-2498N8498AAllen Scott C · Mcminnville, ORBuilt 1970 · S/N D-9237N84AKMetro Aviation Inc · Shreveport, LABuilt 1977 · S/N E-1167N84BReturnlogic Inc · Apollo Beach, FLBuilt 1984 · S/N E-2146N84BEVelasquez Daniel A · Winter Park, FLBuilt 1983 · S/N E-2114N84BFEvans Timothy Kent · Fremont, NCBuilt 1983 · S/N E-2112N84BTSoltani Ebrahim · Palos Verdes Est, CABuilt 1990 · S/N EA-509N84DSankofa Air LLC · Wilmington, DEBuilt 1978 · S/N D-10109N84FBJohnson David P · Sycamore, ILBuilt 1977 · S/N D-10059N84KN84k LLC · The Dalles, ORBuilt 1977 · S/N D-10067N84LBLiess Zenda A · Greensboro, NCBuilt 1975 · S/N TE1048N84PECarosso Kevin V · Santa Cruz, CABuilt 1984 · S/N TJ-470N84RSanford David G · Knoxville, TNBuilt 1977 · S/N E-1146N84SRSunnydaze Ltd · Northville, MIBuilt 1972 · S/N CE-377N84WSByham Shawn G C · Lake Havasu City, AZBuilt 1991 · S/N E-2666N85052Gant Dallas C Jr · Wickenburg, AZBuilt 1977 · S/N TE-1095N850TWisdom John D · Mineola, TXBuilt 1972 · S/N D-9367N853Cameo Marketing Inc · Ellsworth, MES/N D-9888N853KTKansas State University Salina · Salina, KSBuilt 1993 · S/N CE-1765N853THumphrey Daniel P · Sausalito, CABuilt 1974 · S/N D-9630N854CBeasley Timber Co Inc · Hazlehurst, GABuilt 2001 · S/N TH-2018N854PRegistered aircraftBuilt 1980 · S/N CE-886N8552RBlanco Diego A · Miami, FLBuilt 1974 · S/N CE-533N855DCCunningham Mark · Paris, TXS/N E-3585N8562RTj Airholdings Inc Owner Trustee · Wilmington, DEBuilt 1974 · S/N CE-534N8564RAnderson Hans C · Leavenworth, WABuilt 1974 · S/N TH-534N8566RSouthwest Fresh Potato LLC · Hugoton, KSBuilt 1974 · S/N D-9684N8568RDavenport Gregory · Edmond, OKBuilt 1974 · S/N TH-525N8577RPhillips Law Firm LLC · Marietta, GABuilt 1974 · S/N E-596N857CTpcj Group LLC · Arlington, TXBuilt 1975 · S/N CE-560N857CGRbf Partners LLC · Chattanooga, TNS/N E-1128N8583RFresa Oro Inc · Carlsbad, CABuilt 1974 · S/N CE-538N8584RRjm Aero Inc · Fallbrook, CABuilt 1974 · S/N CE-539N8586RRj Sprik Aviation Services LLC · La Porte, INFirst renewal noticeBuilt 1974 · S/N CE-540N858ALFinnegan Brian · Novato, CABuilt 1990 · S/N E2544N858LPFulps Aviation LLC · Winston Salem, NCBuilt 1978 · S/N TH-902N858MLLang Inc · Wilmington, DEBuilt 1980 · S/N TJ-257N858NCIal Corp · Lewes, DEBuilt 1977 · S/N TH-813N858PTj-128 LLC · Dover, DES/N TJ-128N858PBEast Ky Mobile Movers Inc · Pikeville, KYS/N TH-1541N858PRMelbourne Air Partners LLC · Indialantic, FLBuilt 1981 · S/N TH-1221N858TCH2 Transportation LLC · Macon, GABuilt 1979 · S/N TK-98
Back to AD 87-18-06 R1