Registered aircraft · 385

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

N19SPNew York State Police · Albany, NYS/N 64-13666 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, GAFirst renewal noticeS/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

Back to AD 2002-01-31