OpenAirDocs.org
AD 88-21-07 R1

Registered aircraft · 1,267

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:88-21-07-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:88-21-07-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.

N25PKPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7754105N2604ZBurgan Grover W · Jacksonville, FLBuilt 1981 · S/N 27-8154012N2608ZKaufield John E · Garden Prairie, ILBuilt 1981 · S/N 27-8154015N26FTDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-7754059N270GGSkylens LLC · Hammond, LABuilt 1975 · S/N 27-7554085N270RBaxter Thomas L · Stockbridge, GABuilt 1958 · S/N 23-1456N270WMsc Services Inc · Hugo, OKS/N 27-2129N272GBaudouin Dameries · Pagosa Springs, COS/N 27-4189N273BTN273bt Air LLC · Sweetser, INBuilt 1979 · S/N 27-7954112N273RRJet Set Aircraft Inc · Van Nuys, CABuilt 1965 · S/N 27-3020N27CYSale Reported · Hastings, FLSale reportedBuilt 1976 · S/N 27-7654118N27FMGogoplex LLC · Wilmington, DEBuilt 1976 · S/N 27-7654087N27HPTrinair Aviation LLC · Hampshire, ILBuilt 1962 · S/N 27-2034N286DDKhag Aviation Inc · Woodbridge, NJS/N 27-7854019N28WRN28wr LLC · Simpsonville, SCBuilt 1971 · S/N 27-4626N290MSurging Skyward Inc · Newtown, PAS/N 27-7554111N290VGAlmy David W · Riverside, CAS/N 23-5N291VPSeacrest Enterprises LLC · Asheville, NCS/N 27-8154025N295SBChagres Aero LLC · Albuquerque, NMBuilt 1979 · S/N 27-7954091N299RMGulf Atlantic Airways Inc · Gainesville, FLBuilt 1979 · S/N 27-8054024N29AHRiseaero LLC · Florence, SCS/N 27-398N2FXPlane Crazy Aviation LLC · Hollywood, SCBuilt 1966 · S/N 27-3147N2HRWertheim Michael S · Fort Pierce, FLBuilt 1974 · S/N 27-7405342N2QWPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7754126N2RPFasken Frank Andrew · Paris, TXS/N 27-7754160N3019PNelson Matthew J · Frewsburg, NYBuilt 1957 · S/N 23-928N301SWFly Rite Aviation LLC · Fort Myers, FLS/N 27-195N3024PPrentice Robert D · Ripon, WIBuilt 1957 · S/N 23-935N3032PMenard Charles H · Grand Blanc, MIBuilt 1957 · S/N 23-943N3048PMeginnes Mark A · Tucson, AZBuilt 1957 · S/N 23-959N3049PTaildragger Aero LLC · Saint John, WABuilt 1957 · S/N 23-961N3063PWillis William P Trustee · New Palestine, INS/N 23-981N3066PMatanane Rokie C · Barrigada, GUBuilt 1957 · S/N 23-984N3070PParker Anthony C · New Ipswich, NHBuilt 1957 · S/N 23-988N3073PPerry Edward Glen Trustee · Ozark, ARBuilt 1957 · S/N 23-991N3081PVan Zant Robert E · Salem, WIS/N 23-999N3086HGenesis Aviation Enterprises Inc · Fort Lauderdale, FLS/N 27-7754144N30CPSkyveris LLC · Simi Valley, CABuilt 1973 · S/N 27-7305022N3119PKovacs Thomas A · Nashua, NHBuilt 1957 · S/N 23-1041N311BBCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1966 · S/N 27-3313N311JEJps Aviation LLC · West Chicago, ILS/N 27-7754053N3126PJmc Duryea Investments LLC · Ocala, FLBuilt 1957 · S/N 23-1049N3127PThorn Blake A · Coupeville, WAS/N 23-1050N3129PJudie Bear Air LLC · Bend, ORBuilt 1957 · S/N 23-1052N3132PSarratt Curtis H · Annapolis, MDBuilt 1957 · S/N 23-1056N3133PLumley John J · Delray Beach, FLBuilt 1957 · S/N 23-1057N3134PSchmidt Casey D · Cedar Rapids, IAS/N 23-1059N3144PEurohaus LLC · Phoenix, AZBuilt 1957 · S/N 23-1075N314KBMatthews Grover C · Hardinsburg, KYBuilt 1958 · S/N 23-1391N315NYPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7754031
Back to AD 88-21-07 R1