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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N1MXWsh LLC · Palmer, AKS/N 62-01995 N20446Agriforrestal Applications Inc · Arcadia, FLBuilt 1963 · S/N 63-8770 N2048PNorthwest Helicopters LLC · Olympia, WAS/N 65-9602 N204BMToucan Helicopter Co Ltd · Fayetteville, GAS/N 68-15683 N204BSIntermountain Helicopters Inc · Cottage Grove, ORBuilt 1963 · S/N 63-8699 N204DSGreenwood Helicopters Inc · Washington, NCBuilt 1960 · S/N 60-3594 N204DXFarwest Aviation LLC · Billings, MTS/N 61-787 N204GPJones Aviation Inc · Biggs, CABuilt 1964 · S/N 64-14073 N204HTJones Flying Service · Biggs, CABuilt 1962 · S/N 62-2078 N204JBPremier Aircraft Services LLC · Bakersfield, CABuilt 1963 · S/N 63-13088 N204UHR&R Conner Aviation LLC · Conner, MTBuilt 1962 · S/N 62-2034 N2055VBrown Helicopter Inc · Pensacola, FLBuilt 1966 · S/N 66-1023 N205DPDillon Uh-1h LLC · Scottsdale, AZBuilt 1968 · S/N 68-16056 N205FUAir 1 LLC · Newark, DEBuilt 1970 · S/N 70-16416 N205FWPasco Sheriffs Office · New Port Richey, FLS/N 69-15585 N205GEAv8-Orr Helicopter Services Inc · Hamilton, MTBuilt 1969 · S/N 69-15198 N205KPSchaper Monte E · Terra Bella, CAS/N 62-02108 N205KSUsda Forest Service Fepp · Santa Barbara, CAS/N 9526 N205LECollier County Sheriffs Office · Naples, FLS/N 69-15533 N206NJPope James D · Clarkston, WABuilt 1962 · S/N 62-1934 N207SDU S Dept Of State Inl/A · Melbourne, FLS/N 74-22359 N216WCBrown Helicopter Inc · Pensacola, FLS/N 7016216 N221HFArmy Aviation Heritage Foundation Inc · Hampton, GAS/N 70-16221 N2220FAmerican Huey 369 Inc · Peru, INS/N 63-12959 N222RRAir Ball Productions LLC · White Deer, TXBuilt 1977 · S/N 13894 N224SPNew York State Police Aviation Unit · Albany, NYS/N 73-21721 N2252APremier Aircraft Services LLC · Bakersfield, CABuilt 1961 · S/N 61-0798 N22753Martins Dusters Inc · Colusa, CABuilt 1964 · S/N 64-13985 N234GSFriends Of Army Aviation · Ozark, ALS/N 69-15545 N234SJPorter Flying Services Inc · Chico, CABuilt 1962 · S/N 388 N240GHYankee Air Force Inc · Belleville, MIBuilt 1966 · S/N 66-01126 N2417UDavid Abreu Vineyard Management Inc · Rutherford, CAS/N 017549 N241SDBrown Helicopter Inc · Pensacola, FLS/N 71-20040 N242KCUsda Forest Service · Bakersfield, CAS/N 6717842 N247PVPacific Valley Aviation Inc · Arbuckle, CABuilt 1965 · S/N 65-9649 N248SDU S Dept Of State Inl/A · Melbourne, FLS/N 74-22467 N256KTKord Technologies Inc · Huntsville, ALS/N 69-15075 N25UKOrlando Aircraft Sales LLC · Orlando, FLBuilt 1964 · S/N 64-13619 N262RCUS Airlift Command Inc · Anderson, SCBuilt 1971 · S/N 70-16443 N264RMRocky Mountain Construction LLC · Klamath Falls, ORBuilt 2012 · S/N 70-16424 N271GHAmerican Huey 369 Inc · Peru, INS/N 151271 N281AHJareds Military Aircraft Group · Odessa, MOS/N 67-17146 N284MMMarble Mountain Helicopters LLC · Roseburg, ORBuilt 1964 · S/N 6413813 N285MMMarble Mountain Helicopters LLC · Roseburg, ORS/N 65-10029 N2956FAvag Inc · Richvale, CAS/N 63-12950 N30111Sky Walker Aviation LLC · Indianapolis, INBuilt 1968 · S/N 68-16563 N301HPPope Jim D · Clarkston, WABuilt 1965 · S/N 65-10017 N302DTTop Hand Inc · Laurel, MTS/N 68-15450 N302WHNorthwest Helicopters LLC · Olympia, WAS/N 7422302 N3053QWest Valley Aviation Inc · Five Points, CABuilt 1966 · S/N 66-1104

Back to AD 2000-15-21 R1