OpenAirDocs.org
AD 81-11-02 R1

Registered aircraft · 1,752

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:81-11-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:81-11-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.

N286NDMorris Randall Sanford Hartnett · Fort Worth, TXBuilt 2000 · S/N 2844035N2873LShelton Brad · Wildwood, MOBuilt 1979 · S/N 28R-7918188N2873RMitchell Daniel E · Lubbock, TXBuilt 1969 · S/N 28R-35312N2875RLyons Corey · Vinton, OHS/N 28R-35315N2876RTorley Air Service LLC · Colorado Springs, COBuilt 1969 · S/N 28R-35316N2878NRace Ralph D · Brookland, ARS/N 28R-7918194N2878ULundstroem Ulf · Fort Pierce, FLS/N 28R-7918195N2879YDawson Ronald Dwight Sr · Garland, TXBuilt 1987 · S/N 28R-7931240N287NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2844036N2880TVuppala Kavya · Springtown, TXBuilt 1972 · S/N 28R-7235151N2882RPostlewait Logging Co · Port Allegany, PABuilt 1969 · S/N 28R-35317N2885RArrow Flight LLC · Springfield, VABuilt 1969 · S/N 28R-35318N2887DTwelve Bits LLC · Fort Lauderdale, FLBuilt 1979 · S/N 28R-7918197N2887QAvalon Global Aviation Inc · Lakeland, FLS/N 28R-7918199N2888TValenstein Glenn L · Howards Grove, WIBuilt 1972 · S/N 28R-7235153N2889TRegistered aircraftBuilt 1972 · S/N 28R-7235154N2895CZeira Eldad M · Encinitas, CABuilt 1979 · S/N 28R-7918203N2895DSaylor Edward T III · Mesa, AZS/N 28R-7918204N2895LSam001 LLC · Miami Beach, FLBuilt 1979 · S/N 28R-7918205N2895NSebion Michael I · Westby, WIBuilt 1979 · S/N 28R-7918206N2895TSr Patel LLC · Meadville, PABuilt 1972 · S/N 28R-7235156N2896RHuseman Adam · Clarinda, IABuilt 1969 · S/N 28R-35322N289NDLoyd Fred Wayne · Rossville, GABuilt 2000 · S/N 2844039N289PAGenn Tx LLC · Farmersville, TXBuilt 2002 · S/N 2844065N28LEGlenn Scott A · Overland Park, KSBuilt 1976 · S/N 28R-7635253N28UPStoddard Donald W · Great Falls, MTBuilt 1973 · S/N 28R7335386N29021Kough Brian R · Plant City, FLBuilt 1979 · S/N 28R-7918133N2903TDragonguard LLC · Lake City, FLBuilt 1979 · S/N 28R-7918209N2904AFlight Unlimited Inc · Riverview, MIBuilt 1979 · S/N 28R-7918212N2907RFricks Cline Thomas Jr · Toccoa, GABuilt 1969 · S/N 28R-35324N2911PHayes Gregory S · Edinboro, PABuilt 1979 · S/N 28R-7918216N2914RLandrith Robert L · Mustang, OKBuilt 1969 · S/N 28R-35327N2917RCzarnecki Neil A · Racine, WIBuilt 1969 · S/N 28R-35328N2918BMorris Robert B · Billings, MTBuilt 1979 · S/N 28R-7918219N2919UFrix Richardd · Bluffdale, UTBuilt 1979 · S/N 28R-7918220N291MCGonzalez Joseph III · Saginaw, TXBuilt 1972 · S/N 28R-7335026N2921RZiegler James F · Darwin, MNBuilt 1969 · S/N 28R-35329N2924MJones Joshua D · Gallatin Gateway, MTBuilt 1977 · S/N 28R-7837105N2925NClausen Steven L · Hallam, NES/N 28R-7918223N2925RSpeedbird Aviation Alpha Charlie LLC · Glenn Heights, TXBuilt 1969 · S/N 28R-35330N2927MCooney Francis M · Sunriver, ORBuilt 1977 · S/N 28R-7837106N2927QWifa (Washington International Flight Acad) LLC · Gaithersburg, MDS/N 28R-7737043N29305Mbs Aircraft Inc · Saginaw, MIBuilt 1979 · S/N 28R-7918134N2930RSouthern Warriors International Inc · Port Saint Lucie, FLBuilt 1969 · S/N 28R-35332N29310Talbert James D · Alamogordo, NMBuilt 1979 · S/N 28R-7918139N2936NTailwinds Aviation LLC · Crystal Lake, ILBuilt 1979 · S/N 28R-7918229N293FSBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2018 · S/N 2844176N293MGGeorgia Aviation Authority · Eastman, GABuilt 2015 · S/N 2844155N2940QSkyhawk Flying Club Inc · Omaha, NES/N 28R-7737044N2940RRespass Keith D · Bluffton, SCBuilt 1969 · S/N 28R-35334
Back to AD 81-11-02 R1