OpenAirDocs.org
AD 81-11-02 R1

Registered aircraft · 1,753

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.

N9493NHigh Prairie Aviation LLC · Washington, IABuilt 1969 · S/N 28R-35214N9495NNagel Richard A · Mequon, WIBuilt 1969 · S/N 28R-35216N9498KDirksen Caleb A · Garner, IABuilt 1976 · S/N 28R-7635245N9498NKoehler Scott A · Brighton, ILBuilt 1969 · S/N 28R-35219N9499NFlight Niner Niner LLC · Charleston, SCBuilt 1969 · S/N 28R-35220N94NARegistration Pending · Northampton, MARegistration pendingS/N 2844003N94PMKingdom Planes LLC · Decatur, TXBuilt 1982 · S/N 28R-8218018N94RRMaxwell Theresia · Charlotte, NCBuilt 1979 · S/N 28R-7918144N950DSSchmitt Douglas F · Bloomsbury, NJBuilt 1978 · S/N 28R-7837167N9539CNafziger Aviation Leasing LLC · Wittman, MDBuilt 1978 · S/N 28R-7837206N9555KHiggins Donald Aubrey Sr · Cornelia, GAS/N 28R-7635249N956SAAir Statler LLC · Harbor Springs, MIS/N 28R-7435054N9594CPassino Nicholas J · Latham, NYBuilt 1978 · S/N 28R-7837209N959ACQualitair LLC Trustee · MichelstadtBuilt 1980 · S/N 28R-8118009N95HFEddings Samuel David · Camino, CABuilt 1973 · S/N 28R7335311N95PGAviation Sensation LLC · Clearwater, FLBuilt 1974 · S/N 28R-7535026N9608KPiper Arrow N9608k LLC · Ann Arbor, MIBuilt 1976 · S/N 28R-7635250N962MSMt San Antonio College · Walnut, CABuilt 1976 · S/N 28R-7635459N962WWMindlin Frank August · New Haven, CTBuilt 2000 · S/N 2844022N9634K137 Lynwood LLC · Elmira Heights, NYS/N 28R-7635251N963WWCash Management Consulting LLC · Granite Springs, NYBuilt 2000 · S/N 2844023N9644KLuck Aviation LLC · Glen Allen, VABuilt 1976 · S/N 28R-7635252N9659KBell Michael J · Duck Key, FLBuilt 1976 · S/N 28R-7635254N9686KGaasedelen Trading Co · Edina, MNBuilt 1976 · S/N 28R-7635255N9690CWindsock Inc · Red Wing, MNBuilt 1978 · S/N 28R-7837216N9701KEmory Christopher W · Lexington Park, MDBuilt 1976 · S/N 28R-7635257N9721CFlorida Aviation Career Training Inc · Saint Augustine, FLS/N 28R-7837218N9722CRobbins Joseph R · Madison, ALBuilt 1978 · S/N 28R-7837219N972LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 2844172N972MWKo Hee Sun · Norwood, NJBuilt 1999 · S/N 2844019N973LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 2844173N9764KSchoff Wardell R · Hamilton, MOBuilt 1977 · S/N 28R-7837038N9777MEgs Air LLC · St Thomas, VIBuilt 2004 · S/N 2844116N977BCPilots Flying School LLC · Englishtown, NJBuilt 1976 · S/N 28R-7635326N9789CLinares Carlos W · Concord, CABuilt 1978 · S/N 28R-7837221N97UAManufacturing Services And Solutions LLC · Lake Villa, ILBuilt 1978 · S/N 28R7837163N9809KS&S Investment Solutions LLC · Lakeland, TNBuilt 1977 · S/N 28R-7837039N980ACNaples Air Center Inc · Naples, FLBuilt 2001 · S/N 2844051N9817KN9817k LLC · Fredricksburg, VABuilt 1977 · S/N 28R-7837040N987EGPensacola Navy Flying Club Inc · Pensacola, FLBuilt 1972 · S/N 28R-7335027N987TDRegistered aircraftBuilt 1974 · S/N 28R-7535075N9890KWilliams Robert · Dawsonville, GABuilt 1977 · S/N 28R-7837046N98JGDistrict Board Of Trustees Miami Dade College Fl · Miami, FLBuilt 1969 · S/N 28R-35117N98UAKnox Kevin J · Verdi, NVBuilt 1980 · S/N 28R-8018035N991VTCrosswinds Flying Club Inc · Bloomington, ILBuilt 1978 · S/N 28R-7837267N994BCEast Coast Flyers LLC · Rockville, MDBuilt 1970 · S/N 28R-7135036N999ADAllison Aviation LLC · Pueblo, COS/N 28R-7235117N999RJReschke William E · San Diego, CABuilt 1969 · S/N 28R-35169N999VFCrawford David B · Warren, OHBuilt 1971 · S/N 28R-7135143N99R206aa LLC · Saint John, INBuilt 1969 · S/N 28R-35160
Back to AD 81-11-02 R1