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.

N6871JRyan Air Ventures LLC · Auburn, GABuilt 1976 · S/N 28R-7635354N6878JLake Stephen · Geary, OKBuilt 1976 · S/N 28R-7635355N687BHTrmg Consulting Services LLC · Edison, NJS/N 28R-7737042N688BGJones William E · Birmingham, ALBuilt 1969 · S/N 28R-35023N68CNEichten Steve G · Colleyville, TXBuilt 1969 · S/N 28R-35388N68JALost Aviators LLC · Durant, OKBuilt 2001 · S/N 2844057N6905JDouble Delta Sierra LLC · Bristol, CTBuilt 1976 · S/N 28R-7635359N691RPRegistration Pending · Mount Holly, VTRegistration pending, canceledBuilt 1969 · S/N 28R-35019N6932JRamonetta Vince · Westbrook, CTS/N 28R-7635362N6944JJhap LLC · Hubbard, OHBuilt 1976 · S/N 28R-7635364N6948C48 Charlie LLC · Columbia, MDS/N 28R-7837177N6952CSnoz Inc · Sharon, MABuilt 1978 · S/N 28R-7837178N6952JLagimoniere Gregory · Jacksonville Beach, FLBuilt 1976 · S/N 28R-7635365N6973JStracener Adam · Pittsburg, TXBuilt 1976 · S/N 28R-7635369N697FTSilvey Michael Duane · Newhall, CABuilt 1973 · S/N 28R-7335140N697LBMtt Aviation Services Inc · Johnstown, PABuilt 1979 · S/N 28R-7918112N6983JLaid Back Investment Holdings LLC · Cairo, GABuilt 1976 · S/N 28R-7635371N6995CDetert Bradley · Valparaiso, INBuilt 1978 · S/N 28R-7837180N6998NPacifica LLC · Grand Junction, COS/N 28R-35797N6999JSun West Aviation Inc · Santa Ynez, CABuilt 1976 · S/N 28R-7635373N69GSDaphnee Moise Md Pa · Sarasota, FLBuilt 1972 · S/N 28R-7235275N69MWOlson James H · Eleva, WIBuilt 1975 · S/N 28R-7635064N69PAWanagel Joshua · Berwyn, PABuilt 1969 · S/N 28R-35159N6ECDraco Flight School Inc · Chino, CABuilt 1974 · S/N 28R-7435220N7000XWalsh Peter F · Walpole, MABuilt 1971 · S/N 28R-7135172N701CAMkc Aviation LLC · St George, UTBuilt 1973 · S/N 28R-7435107N701DCBlack Cat Aviation LLC · Indianapolis, INBuilt 1973 · S/N 28R-7435020N701EAPratt Thomas · Muncie, INBuilt 1973 · S/N 28R-7435036N701RALaith Aviation LLC · Goose Creek, SCBuilt 1973 · S/N 28R7335415N7044CPappas Tevis · Atlanta, TXBuilt 1975 · S/N 28R-7635092N705WHSky Craft LLC · Powell, OHBuilt 1978 · S/N 28R-7918019N70EF720 Degrees Inc · Santa Monica, CABuilt 1972 · S/N 28R-7335064N70MHN70mh LLC · Wilmington, DEBuilt 1976 · S/N 28R-7635390N711ABL J S Enterprises Inc · Albany, TXBuilt 1969 · S/N 28R-35189N711CVSmtm Holdings Inc · Wilmington, DEBuilt 1971 · S/N 28R-7135212N7194CCivil Air Support LLC · Phoenix, AZBuilt 1975 · S/N 28R-7635096N71EFSandercock Mark L · Pewaukee, WIBuilt 1972 · S/N 28R-7235176N720GCCox Gary E · Davis, CABuilt 1972 · S/N 28R-7235317N722WMPegasus Enterprises LLC · Granbury, TXS/N 28R-7435045N7271CChesley James Philip · Mesa, AZBuilt 1975 · S/N 28R-7635098N727HSSandstar Aviation LLC · Lewes, DES/N 28R-7335432N7284CSeed Richard J IV · Wicomico Church, VAS/N 28R-7635099N72MHQuasar Aircraft Corp · Jacksonville, FLBuilt 1978 · S/N 28R-7918008N730XSbh Alliance LLC · Sauk Rapids, MNBuilt 2002 · S/N 2844066N743EDAir Adventure LLC · Sheridan, WYBuilt 1977 · S/N 28R-7837096N746BCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1974 · S/N 28R-7435187N749CSBower John M · Santa Cruz, CABuilt 1976 · S/N 28R-7635222N75046Esson Michael · Durand, MIS/N 28R-7635261N75050Delaware State University · Dover, DEBuilt 1976 · S/N 28R-7635262N75127Amob 2 LLC · Baton Rouge, LABuilt 1976 · S/N 28R-7635267
Back to AD 81-11-02 R1