OpenAirDocs.org
AD 87-21-02 R1

Registered aircraft · 3,961

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-21-02-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-21-02-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.

N5454XKair Aviation · Parkland, FLS/N 340A1512N545MMage Aircraft Leasing LLC · San Antonio, TXS/N 340A1041N5461JGlyn Dwr Aviation LLC · Kalispell, MTS/N 310R0259N5461VGoldt Robert · Simpsonville, SCS/N T30300300N5474JRedick Albert L II · Reno, NVBuilt 1975 · S/N 310R0272N5478GOn Wings Of Eagles LLC · Valley Center, CABuilt 1976 · S/N 421C0225N5479JBluegoose Aviation LLC · Muscle Shoals, ALBuilt 1975 · S/N 310R0277N5484JCaba Joseph · Covington, LAS/N 310R0282N5488JGrace Aviation LLC · Rogers, ARBuilt 1975 · S/N 310R0286N548GAHyannis Air Service Inc · Hyannis, MABuilt 1982 · S/N 402C0653N5490JCullen Clay T · Danbury, CTS/N 310R0288N5495JMesquite Express LLC · Waco, TXBuilt 1975 · S/N 310R0293N5497GRichardson Farms Land Mgt Inc · Pittsfield, ILS/N 421C0244N54CRCage Presnall C · Falfurrias, TXS/N 421C0812N54DFSkywave Associates LLC · Spirit Lake, IABuilt 1972 · S/N 340-0172N54GSN28hb LLC · New York, NYS/N 340A0456N54JQRegistered aircraftN-number assigned (import), not yet registeredS/N 414A0086N54SADodson International Parts Inc · Rantoul, KSS/N 404-0426N54TTRedcell Air Inc · Miami, FLBuilt 1981 · S/N 421C1054N54ZPSouth Aero Inc · Albuquerque, NMBuilt 1980 · S/N 404-0694N550BRF P And P I Enterprises Inc · Oceanside, CABuilt 1974 · S/N 414-0533N550FSRegistration Pending · Sheboygan Falls, WIRegistration pendingBuilt 1968 · S/N 401-0289N550SNortheast Cubs LLC · Wilmington, DEBuilt 1976 · S/N 340A0086N5515CIsland Fliers LLC · Sheridan, WYBuilt 1982 · S/N T30300142N5529VCandlestick Aviation Services LLC · Lewes, DEBuilt 1984 · S/N T30300303N552SSky'S The Limit Aviation LLC · Wilmington, DES/N 340-0170N553LPMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1978 · S/N 414A0092N553SWHeritage Air LLC · Grove, OKBuilt 1981 · S/N 414A0614N554CCAmg/Sherfick Aviation LLC · Noblesville, INBuilt 1982 · S/N 421C1228N5554GGaluk Douglas P · Wisconsin Rapids, WIBuilt 1977 · S/N 421C0249N555CPFirebird Air LLC · Fulshear, TXBuilt 1979 · S/N 340A0651N555CTN555ct LLC · Largo, FLBuilt 1981 · S/N 414A0822N555JDMike Bravo LLC · Chicago, ILBuilt 1979 · S/N 310R1629N555KKGe Flyer 1 LLC · Sheridan, WYS/N 421C1022N555MVDavis Elijah L · West Union, OHBuilt 1966 · S/N 310K0186N555MYSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1974 · S/N 421B0886N555RFRayburn Aviation LLC · Center, TXBuilt 1974 · S/N 421B0621N555TYKiefer Karl F · Spring, TXBuilt 1974 · S/N 340-0515N555WPSherry-Aire LLC · Sidney, MTS/N 414A0074N558BFMatrix Aviation LLC · Birmingham, MIS/N 421C0845N558BTKeesling Roger L · Starkville, MSBuilt 1969 · S/N 310P0220N55ABAllan Michael D · Forney, TXBuilt 1974 · S/N 310R0038N55BFrankel Cary S · Harrison, NYBuilt 1979 · S/N 310R1830N55CMCamille Ventures LLC · Odessa, TXBuilt 1973 · S/N 4140423N55LPAir Flight Inc · Fort Lauderdale, FLBuilt 1980 · S/N 402C0401N55LTRegistration Pending · Tucson, AZRegistration pendingS/N 414-0926N55PPChaffey Community College District · Rancho Cucamonga, CABuilt 1972 · S/N 414-0366N55RBGots To Go LLC · Wilmington, DEBuilt 1975 · S/N 340A0015N55RLSound Harbor Aviation LLC · Wilmington, NCS/N 421C1071N55WSFour To One LLC · Decatur, ALBuilt 1976 · S/N 421C0073
Back to AD 87-21-02 R1