OpenAirDocs.org
AD 2000-15-21 R1

Registered aircraft · 378

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:2000-15-21-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:2000-15-21-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.

N791CFHagglund Carl D · Pendleton, ORS/N 68-16245N794CFAlabama Center Of Military History · Huntsville, ALS/N 63-08794N795CFAlabama Center Of Military History (Acmh) · Huntsville, ALS/N 65-10026N79NWCbft LLC · Mobile, ALBuilt 1964 · S/N 64-13710N803UHAmerican Huey 369 Inc · Peru, INBuilt 1963 · S/N 63-08803N8043ZMagnum Aviation LLC · Goff, KSS/N 60-3552N8053TCoastal Helicopters Inc · Panama City, FLS/N 69-15321N8053YCoastal Helicopters Inc · Panama City, FLS/N 66-01093N806SBScotts Helicopter Service · Le Sueur, MNBuilt 1964 · S/N 64-14023N80780Gagnon Roger M · Redding, CAS/N 64-13820N8079EGagnon Roger M · Redding, CAS/N 65-09718N80JGJimmy Graham Foundation Inc · Miami, FLS/N 67-17279N80NHMccarty David · La Grande, ORBuilt 1970 · S/N 70-16267N81217US Dept Of State Inl/A · Melbourne, FLS/N 74-22327N8122NUS Dept Of State Inl/A · Melbourne, FLS/N 73-21742N812SBCavanaugh Air LLC · Addison, TXBuilt 1964 · S/N 64-13553N815SCSnohomish County Sheriffs Office · Snohomish, WAS/N 70-15757N82121US Dept Of State Inl/A · Melbourne, FLS/N 73-21828N823LWLiberty War Bird Inc · Lititz, PABuilt 1966 · S/N 66-16823N8240XUS Department Of State · Melbourne, FLS/N 70-16285N82419US Department Of State · Melbourne, FLS/N 71-20009N827STMi State Police Field Supp Aviation · Lansing, MIS/N 74-22443N832DHSkyhop LLC · Santa Rosa, CABuilt 1967 · S/N 67-17659N832MStarks Daniel · Dubois, WYBuilt 1963 · S/N 62-2084N841FCsw LLC · Anacoco, LABuilt 1965 · S/N 65-7922N841MRock Creek Leasing LLC · Sapulpa, OKBuilt 1962 · S/N 62-1956N850MJones Aviation · Biggs, CABuilt 1966 · S/N 66-16875N851TPIkarus Aviation LLC · Salt Lake City, UTS/N 66-16071N854MJones Aviation Inc · Biggs, CAS/N 66-01062N857SDRegistration Pending · Anchorage, AKRegistration pendingBuilt 1963 · S/N 63-08857N858MPacific Valley Aviation Inc · Arbuckle, CABuilt 1966 · S/N 66-17114N874High Performance Helicopters Corp · Crestline, CABuilt 1965 · S/N 65-12874N876EMNorthwest Helicopters LLC · Olympia, WAS/N 66-16048N876GMNorthwest Helicopters LLC · Olympia, WAS/N 66-16006N88976R Consulting & Sales Inc · Carson City, NVS/N 64-14009N88992Premier Aircraft Services LLC · Bakersfield, CABuilt 1961 · S/N 61-0718N891PMPorter Flying Service Inc · Chico, CABuilt 1971 · S/N 7120012N892PMPm Dusters · Durham, CAS/N 68-16476N893PMPorter Flying Service · Durham, CABuilt 1962 · S/N 62-1923N902HEDown East Emergency Medicine Institute · Orono, MES/N 67-17396N910KCKnox County Sheriffs Office · Knoxville, TNS/N 63-12991N911BVJones Aviation Inc · Biggs, CABuilt 1966 · S/N 65-09785N911CECoastal Air Service Inc · Panama City, FLS/N 64-13819N911GCSacramento County Sheriffs Department · Mather, CAS/N 66-00883N911JMEmu Inc · Redwood City, CABuilt 1965 · S/N 65-09870N911KKCollings Foundation · Stow, MABuilt 1966 · S/N 153762N911KPSanta Barbara Sheriffs Dept · Santa Barbara, CAS/N 65-10061N911MRChelan County Fire District No 1 · Wenatchee, WAS/N 65-09710N911NNTehama County Sheriff'S Office · Red Bluff, CAS/N 71-20068N911PRChelan County Fire District No 1 · Wenatchee, WAS/N 65-09877
Back to AD 2000-15-21 R1