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.

N442RWRobertson David · Cullman, ALS/N TE-885N442WHayden Stephen Lin · Raton, NMBuilt 1987 · S/N E-2356N4430WMagerit Aviation Inc · South Boston, MABuilt 1974 · S/N D-9609N4431WUnited Roofing Of Central Florida Inc · Ocala, FLBuilt 1974 · S/N D-9606N4432ABrown David L · Gold Hill, NCBuilt 1970 · S/N D-9144N4432YFraiman Douglas E · Homer, AKBuilt 1979 · S/N E-1614N4433ATiger Air International LLC · Palm Bay, FLS/N CE1535N4434WP Scarlett Inc · Plattsmouth, NEBuilt 1975 · S/N E-742N4435VMacdonald Glenn · Sugar Land, TXFirst renewal noticeBuilt 1979 · S/N D-10225N443PFrederick Investment Corp · Raleigh, NCBuilt 1999 · S/N TH-1914N4449WJameson Clarke Enterprises LLC · Houston, TXBuilt 1974 · S/N TH-451N4449YTx Waste Ventures LLC · Caddo Mills, TXBuilt 1975 · S/N E-657N444AFContinental Aero Associates Inc · Grosse Pointe Park, MIBuilt 1974 · S/N D-9590N444CCVon Almen James Martin · Lewisburg, TNBuilt 1979 · S/N CE-845N444DGSwanson Douglas A · Marana, AZS/N D-9882N444DKPiggott Russell T · Fresno, CABuilt 1979 · S/N D-10296N444DWTriple 4 Dw LLC · Davie, FLBuilt 1972 · S/N D-9416N444FCCentric It Resources LLC · Loomis, CABuilt 1981 · S/N EA-257N444PGN444pg Aviation LLC · Charleston, SCBuilt 1998 · S/N E3218N444RGKalasky Sean W · Jacksonville Beach, FLBuilt 1976 · S/N CE-644N444RUFitzgerald Paul · Grapevine, TXBuilt 1973 · S/N D-9441N444SRr&D Lp · Fayetteville, NCBuilt 1985 · S/N TJ-490N444SHScheinman David · Woodside, CABuilt 1986 · S/N CE-1079N444TCHalstead Land & Cattle Inc · Arnold, NEBuilt 1975 · S/N D-9783N444WELiberty Steaks LLC · Latham, NYBuilt 2004 · S/N E-3579N444WRNuccio Jeffrey W Trustee · Signal Mountain, TNBuilt 1977 · S/N D-10012N4451SCaporale Ron · Dillon, MTBuilt 1975 · S/N E-683N4451WFlying On Edge LLC · Redmond, WABuilt 1974 · S/N CE-491N4452WHubbard Mark A · Wilmington, DEBuilt 1974 · S/N D-9611N4456SFressh Air LLC · Vancouver, WABuilt 1975 · S/N E-688N4456WMetal Finishing Co Inc · Wichita, KSBuilt 1974 · S/N E-537N4457SRegistered aircraftBuilt 1975 · S/N D-9775N4458ARaimondi Johann I · Doral, FLBuilt 1970 · S/N D-9145N4458SCn Aviation LLC · Mesa, AZBuilt 1976 · S/N TJ-58N4459SJameson Kelly J · Chappell Hill, TXBuilt 1975 · S/N E-692N445HPChopra Family Lp · Tulare, CABuilt 1985 · S/N EA-445N445PWelsh Steven M · Oxford, NCBuilt 2001 · S/N E-3415N4460S300 Dollar Burger LLC · Elmhurst, ILBuilt 1975 · S/N E-691N4463SJ&J Aviation LLC · Hendersonville, TNBuilt 1975 · S/N CE-580N4464WMantei & Associates Ltd · Lexington, SCBuilt 1974 · S/N E-543N4465SFtp LLC · Newington, CTBuilt 1975 · S/N E-693N4466LSmyrna Aviation LLC · Edgewater, FLBuilt 2000 · S/N E-3366N4466SRegistration Pending · West Monroe, LARegistration pendingS/N D-9779N4466WPeregrine Howard Fund V Owner LLC · New Orleans, LABuilt 1973 · S/N TE-936N4467AWynn Andrew J · Montgomery, ALBuilt 1970 · S/N E-212N4467SK & M Leasing Inc · Camden, ARBuilt 1975 · S/N E-694N4468SKyle Robert K · Madison, MSBuilt 1975 · S/N E-696N4468WBorth John D · Meade, KSBuilt 1974 · S/N D-9604N4469RVon V LLC · San Antonio, TXS/N E-3290N4469WDietle Kurt D · Valley Springs, CABuilt 1974 · S/N CE-494
Back to AD 87-18-06 R1