OpenAirDocs.org
AD 86-01-01 R2

Registered aircraft · 59

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:86-01-01-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-01-01-R2')
  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.

N11FVInternational Aor Service Inc Trustee · Carson City, NVBuilt 1982 · S/N T303-00133N1276VNew Horizon Aviation Inc · Warwick, RIBuilt 1984 · S/N T30300262N1385V303 Tango Charlie LLC · Newark, DEBuilt 1984 · S/N T30300266N1919VHigh Mountain Properties LLC · Idaho Falls, IDBuilt 1984 · S/N T30300271N212HRExport Aviation LLC · Santa Fe, NMS/N T30300239N217MEAir Research Ca Inc · Torrance, CABuilt 1983 · S/N T30300188N2268CCozach LLC · Wilmington, DEBuilt 1982 · S/N T30300081N2275CCrusader Medical Consulting LLC · Boonville, INBuilt 1982 · S/N T30300085N27HALmn Aircraft Leasing LLC · Sellersburg, INBuilt 1982 · S/N T30300064N285ATInternational Air Services Inc Trustee · Carson City, NVS/N T30300005N303ABMarc Inc · Bolton, MSBuilt 1981 · S/N T30300028N303CCSpectrum Aviation Inc · Wilmington, DEBuilt 1982 · S/N T30300069N303CGSolomon Mark Trustee · Wilmington, DEBuilt 1981 · S/N T30300022N303CMAdvantage Aviation Inc · Charlotte, NCBuilt 1984 · S/N T30300296N303DBBas Part Sales LLC · Greeley, COBuilt 1981 · S/N T30300043N303DKTrading Planes Inc · Wilmington, DEBuilt 1982 · S/N T303-00068N303HLLao Che Airfreight LLC · North Weymouth, MABuilt 1982 · S/N T30300038N303JPJep Inc · Clarksville, TNBuilt 1982 · S/N T30300067N303KJBrother Michael Andrew · Bedford, TXBuilt 1984 · S/N T303-00301N303KSSmoky Hill Ag LLC · Healy, KSBuilt 1982 · S/N T30300223N303MBN303mb Corp Trustee · Wilmington, DEBuilt 1982 · S/N T30300157N303PBPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N T30300290N303WAWacker Logistics LLC · Naples, FLBuilt 1984 · S/N T30300265N303WJQualitair LLC Trustee · MichelstadtS/N T30300087N303WWQualitair LLC Trustee · MichelstadtBuilt 1983 · S/N T30300226N31KDChinook Fibre LLC · Wilmington, DEBuilt 1984 · S/N T30300310N323TJGuardian Wings LLC · Fredericksburg, VABuilt 1983 · S/N T30300243N33MHAkeyson Edward W · Durham, CTBuilt 1982 · S/N T30300076N382CRSkyport Aviation LLC · Oxford, MIBuilt 1982 · S/N T30300096N412BPMission Hardward Ltd Co · Savannah, GABuilt 1983 · S/N T30300213N4308ZMike Victor Yankee LLC · Andover, MABuilt 1983 · S/N T30300183N4725CContinental Aerospace Technologies Inc · Mobile, ALBuilt 1982 · S/N T30300118N47KKHermansen Dane K · Ormond Beach, FLBuilt 1983 · S/N T30300216N4949CHatchie River Aviation LLC · Kalispell, MTBuilt 1982 · S/N T30300128N494TSDeep Creek Lake Ventures LLC · Oakland, MDBuilt 1983 · S/N T30300201N4HAArrington Harold M · Detroit, MIBuilt 1984 · S/N T30300283N5091CMartin Steven J · Phoenix, AZBuilt 1982 · S/N T30300132N5461VGoldt Robert · Simpsonville, SCS/N T30300300N5515CIsland Fliers LLC · Sheridan, WYBuilt 1982 · S/N T30300142N5529VCandlestick Aviation Services LLC · Lewes, DEBuilt 1984 · S/N T30300303N564RRAlpha Romeo Aviation LLC · Newark, DEBuilt 1982 · S/N T30300136N5ERMill Direct Textiles LLC · Rollinsford, NHBuilt 1982 · S/N T30300137N609DSTj Air Holdings Inc · Wilmington, DEBuilt 1981 · S/N T30300025N6486VVroom Engineering Inc · Tucson, AZBuilt 1984 · S/N T30300311N6498VSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1984 · S/N T30300313N700KBCalifornia Oregon Development LLC · Portland, ORBuilt 1983 · S/N T30300211N707RLApplegate Properties LLC · Morris, ILS/N T303-00008N9330TCrusader 303 LLC · Eugene, ORBuilt 1981 · S/N T30300002N9415CSouthwest Plane Holdings LLC · Kalispell, MTBuilt 1983 · S/N T30300176N9476CZulu Echo Assets LLC · Port Washington, NYBuilt 1982 · S/N T30300179
Back to AD 86-01-01 R2