OpenAirDocs.org
AD 81-12-06 R1

Registered aircraft · 5,102

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-12-06-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-12-06-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.

N653WWBerry Aviation Inc · San Marcos, TXBuilt 2005 · S/N T20608521N65431Caliber Capital Holdings LLC · Homosassa, FLBuilt 2004 · S/N T18208302N65445International Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N T18208322N65452Jf Aviation LLC · Minot, NDBuilt 2004 · S/N T20608491N65459Vitatoe Industries Inc · Chillicothe, OHBuilt 2004 · S/N T20608492N65474Tk Leasing Lc · Fruit Heights, UTFirst renewal noticeBuilt 2004 · S/N T20608493N6549AGregory P Cook LLC · Spokane, WABuilt 1978 · S/N 27-7954006N654MDProfessional Storage Inc · Hobe Sound, FLBuilt 1976 · S/N 27-7754018N654ZZarmada LLC · Issaquah, WABuilt 2006 · S/N T18208627N65515Peterson Darren · Janesville, WIBuilt 2004 · S/N T18208325N6556VGiannola Peter S · San Diego, CAS/N 32-15N6561ARandolph Fielding A M · Jackson, TNBuilt 1978 · S/N 27-7954008N6561YN6561y LLC · Auburn, ALBuilt 1968 · S/N 27-3858N6573YClendenen William M · Spencer, TNBuilt 1968 · S/N 27-3871N6575VGreeson Albert O · Moscow, KSBuilt 1970 · S/N 32-22N6578VPence Dale E · Richmond, MOS/N 31005N6579YTaco Tyme LLC · Hobe Sound, FLBuilt 1968 · S/N 27-3878N65805Wilkerson William E · Crewe, VABuilt 2004 · S/N T18208346N6580VStassen Andrew R · Concord, CABuilt 1969 · S/N 32-16N6583VLedger William V Jr · Shreveport, LABuilt 1969 · S/N 32-20N6588YSo Flipping Busy LLC · Apple Valley, MNBuilt 1968 · S/N 27-3891N65908Sanders Thomas W · Overgaard, AZBuilt 2004 · S/N T18208347N65912Lima Alfa LLC · Whitefish, MTBuilt 2004 · S/N T18208348N6591VEpic Air Power LLC · Newark, DES/N 32-29N65920Hellroaring Technologies Inc · Polson, MTBuilt 2004 · S/N T18208350N65926Pc Aviation LLC · Kanarraville, UTBuilt 2004 · S/N T18208353N65927Garmin International Inc · Olathe, KSBuilt 2004 · S/N T18208354N65932Techflitewest LLC · Brookville, OHBuilt 2004 · S/N T18208356N6594FTabbert William · Diamondhead, MSBuilt 1976 · S/N 32R-7780032N65971Georgalos Aircraft LLC · Eagle Point, ORBuilt 2004 · S/N T18208340N6597VGold Air LLC · Woodland Hills, CABuilt 1970 · S/N 32-24N65CMCapital City Jet Center Inc · Somerset, OHBuilt 1978 · S/N 31-7852077N65DMCorry Aviation LLC · Tequesta, FLBuilt 1973 · S/N 27-7305005N65DTRoberts Aviation Management LLC · Saint Augustine, FLBuilt 1979 · S/N 61P06897963326N65GSCheyenne Air LLC · Charleston, WVBuilt 1983 · S/N 31P-8414016N65MRAtarah LLC · Tucson, AZBuilt 1968 · S/N 31-347N65SCDocs Air LLC · Buffalo, WYBuilt 1974 · S/N 27-7405445N66005Slp III 1 LLC · Columbia, MOBuilt 2005 · S/N T18208359N6601LUnited Jet Sales Inc · Newark, DEBuilt 1977 · S/N 27-7854047N66029Wpf Air LLC · Fort Myers, FLBuilt 2005 · S/N T18208365N660ACSmooth Air LLC · Richboro, PABuilt 1977 · S/N 31-7752142N66100Pj Aviation Holding LLC · Eden Prairie, MNBuilt 2004 · S/N T18208335N6613YAviation Group Jmj Inc · Callahan, FLExpired dealer, pending cancellationBuilt 1969 · S/N 27-4395N66175Stohlquist James R · Alamosa, COBuilt 2005 · S/N T18208414N66177Newman Ken · Hood River, ORBuilt 2005 · S/N T18208375N66184Sec Fl Corp · Santa Rosa Beach, FLBuilt 2005 · S/N T20608518N6619VTeton Leasing LLC · Pocatello, IDBuilt 1968 · S/N 1824-24N661MLDap Aviation LLC · Baton Rouge, LABuilt 1996 · S/N 4636060N661PBravo Tango LLC · Minden, LABuilt 1980 · S/N 32R-8029080N661PC661pc LLC · New Rockford, NDBuilt 2004 · S/N T18208312
Back to AD 81-12-06 R1