AD 98-05-14 R1

Registered aircraft · 909

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:98-05-14-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:98-05-14-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.

N210RBLibrary Interiors Of Florida Inc · Auburndale, FLBuilt 1982 · S/N 21064716N210RDPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N P21000772N210REValiair Lc Trustee · Casper, WYS/N P21000846N210RPRegistration Pending · Charlestown, INRegistration pendingBuilt 1978 · S/N P21000014N210RSInternational Air Services Inc Trustee · Carson City, NVS/N P21000147N210SDArdoin Robin C · Lafayette, LABuilt 1980 · S/N 21064225N210SETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N P21000621N210SLKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1978 · S/N P21000129N210SMMcconnell Peter · Valencia, PABuilt 1979 · S/N P21000370N210SNDominguez Mark J · Many, LABuilt 1980 · S/N P21000548N210SSVucich Bryant · Palm Beach Gardens, FLBuilt 1978 · S/N 21062997N210TGDouble H Enterprises LLC · Bolivar, MOBuilt 1979 · S/N 21063530N210TJJaco Oil Company · Bakersfield, CABuilt 1980 · S/N 21063948N210TPAirborne Enterprises LLC · Ava, MOBuilt 1979 · S/N 21063186N210TSGeary Inc · Westcliffe, COBuilt 1978 · S/N P21000128N210TYRiley Charles · Littleton, COBuilt 1979 · S/N P210-00252N210VBHoogendyk Robert · Big Bear City, CABuilt 1979 · S/N 21063776N210VJV J Wings Inc · Wilmington, DES/N 21063387N210VTStricker Andreas Daniel · Essex Junction, VTBuilt 1980 · S/N P21000522N210VVHeesacker Stephen L Trustee · Los Altos, CABuilt 1979 · S/N 21063214N210WCWeeks Curtis E · Cotulla, TXBuilt 1982 · S/N 21064759N210WJRude Daniel · Leesburg, VABuilt 1982 · S/N 21064734N210WWInternational Air Services Inc Trustee · Carson City, NVBuilt 1982 · S/N P21000808N211CFGoudreau Sean · Mount Dora, FLBuilt 1978 · S/N 21063013N211LR & G Schatz Farms Inc · Lockeford, CABuilt 1979 · S/N 21063183N212SBSycamore Partners LLC · Johnson, ARBuilt 1980 · S/N P21000489N212TSParkside Automotive & Truck Service · Mountain Top, PABuilt 1980 · S/N 21064214N212WKRbm Adventures LLC · Jamestown, NYBuilt 1979 · S/N P21000372N2134UDean Steel Buildings Inc · Fort Myers, FLBuilt 1982 · S/N 21064775N21492Puryear Rodney K · Pampa, TXS/N P21000641N214MKoo C Carlos · Atherton, CABuilt 1985 · S/N P210-00863N215GNBbt Jewelry LLC · Miami, FLS/N P21000335N218CCSotally Tober LLC · Wilmington, DEBuilt 1979 · S/N 21063297N21BESpecialized Helicopter Training LLC · Middleton, IDBuilt 1979 · S/N P21000456N21CTFerreira Douglas B Trustee · Chico, CABuilt 1978 · S/N P21000021N21KRNorcon Enterprises Inc · Amarillo, TXBuilt 1979 · S/N P21000285N21LTMission Flight · El Monte, CABuilt 1979 · S/N P21000216N220TSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N P21000593N220TJJaco Oil Co · Bakersfield, CAS/N 21063139N222ETValiair Lc Trustee · Casper, WYBuilt 1981 · S/N P21000626N222SGPacific Aviation Aircraft Management Inc · Fresno, CAS/N 210-64410N224KAChambers William Melvin Jr · Azle, TXBuilt 1979 · S/N 21063812N224MHFeely Daniel R · Pasadena, CABuilt 1978 · S/N P21000089N224PKValiair Lc Trustee · Casper, WYBuilt 1980 · S/N 21064016N22VFAir Conejos LLC · El Paso, TXBuilt 1978 · S/N P21000106N22WGCorpat Inc · Missoula, MTBuilt 1981 · S/N P21000733N2306DUS Navy - Owner · Jacksonville, FLBuilt 1979 · S/N 21063828N231PTLobbytools Aviation LLC · Friday Harbor, WABuilt 1980 · S/N P21000551N2340UTex-Pan Aviation Inc · Amarillo, TXBuilt 1982 · S/N 21064779N234BWWaring Marvin Barton · Anacortes, WABuilt 1979 · S/N P21000290
Back to AD 98-05-14 R1