Registered aircraft · 1,224

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

N166MBHelicopter Roundup Service LLC · Nephi, UTBuilt 1980 · S/N 1000831D N16715Cahaba Forestry Services LLC · Flowood, MSBuilt 1976 · S/N 2110 N167ALFerguson And Sons Construction LLC · Emmett, IDBuilt 1977 · S/N 270083D N16810Southern Helicopter Services Inc · Millington, TNBuilt 1977 · S/N 2231 N16979Withrotor Aviation Inc · Lakeview, ORS/N 2346 N169AAPierce Associates LLC · Prineville, ORBuilt 1973 · S/N 990 N16EYCarleton Inc Trustee · Wilmington, DEBuilt 1992 · S/N 0501E N16JDTriple F Flying Inc · Benton, PABuilt 1971 · S/N 71-20435 N16QRegistration Pending · Fredericksburg, VARegistration pendingS/N 1290227S N170SSOlathe Spray Service Inc · Olathe, COBuilt 1963 · S/N 2827 N171WHWestwind Helicopters Inc · Santa Fe, TXBuilt 1997 · S/N 53149 N173ALFulton Timothy E · Salem, MOBuilt 1976 · S/N 1160020D N173SJAnthony Ghidossi Chemical LLC · Marysville, WABuilt 1981 · S/N 5170 N1751Gm Leasing Co LLC · Broussard, LABuilt 1981 · S/N 3284 N175HAShearer John · The Dalles, ORBuilt 1978 · S/N HA3075 N175JLRatcliff Dustin · Saltville, VABuilt 1977 · S/N 270076D N175PAMansfield Helifight · Milton, VTBuilt 1997 · S/N 53154 N176PGreenfield Kevin G Trustee · Anchorage, AKS/N 4219 N176PDElon Management LLC · Salem, ORBuilt 2008 · S/N 4658 N177TEllis LLC · Helena, MTS/N 0524E N178PAOrlando Aircraft Sales LLC · Orlando, FLBuilt 1979 · S/N 45319 N179MTAnalar Corp · Princeton, NJS/N 5183 N17NRTrans 5 Investments LLC · Saint Martinville, LABuilt 1972 · S/N 786 N17NXTrans 5 Investments LLC · Saint Martinville, LAS/N 3040 N182AAIndustrial Helicopters LLC · Lafayette, LABuilt 1979 · S/N 2752 N183PSkytech Cc LLC · Santa Rosa Beach, FLBuilt 2000 · S/N E-3346 N183TCLarson Dylan J · Perham, MNS/N 1805 N187GSPort Michael J · Twisp, WABuilt 1978 · S/N 27-0280 N187NDLone Star Helicopters LLC · Lago Vista, TXBuilt 1987 · S/N 3985 N188SHornet International LLC · Picayune, MSS/N 7349 N18CPPeoples Properties LLC · Tucson, AZBuilt 1990 · S/N 383E N190RHLiberty Blades LLC · Flandreau, SDBuilt 1975 · S/N 1687 N192VSVertol Systems Company Inc · Destin, FLBuilt 1980 · S/N 1000786D N193VSVertol Systems Co Inc · Destin, FLBuilt 1981 · S/N 110882D N195VSVertol Systems Co Inc · Destin, FLBuilt 1981 · S/N 110826D N196VSVertol Systems Company Inc · Destin, FLBuilt 1980 · S/N 900787D N197AAChem-Air Inc · Shreveport, LABuilt 1981 · S/N 3517 N198HIndustrial Helicopters LLC · Lafayette, LABuilt 1982 · S/N 3647 N19NGNorgreen Aviation LLC · Kirkland, WABuilt 1975 · S/N 45007 N200VBVertical Vegetation Management LLC · Darlington, INBuilt 1989 · S/N 4070 N201SMDemo Salvage Inc · Calais, MEBuilt 1981 · S/N 3389 N202SCNs Air Leasing LLC · Wilmington, DEBuilt 1982 · S/N 5204 N2043BL&R Investment Partners LLC · Wilmington, DES/N 3355 N2044CScotts Helicopter Service Inc · Le Sueur, MNBuilt 1981 · S/N 3363 N204AVSan Juan Aviation LLC · Wilmington, DEBuilt 1969 · S/N 158 N2060NScotts Helicopter Service Inc · Le Sueur, MNBuilt 1981 · S/N 3327 N2061JHillcrest Aircraft Co Inc · Lewiston, IDBuilt 1982 · S/N 3333 N20683Cascade Helicopters LLC · Canby, ORBuilt 1985 · S/N 3878 N2068AAerial Control Inc · Brentwood, CABuilt 1981 · S/N 3400 N2068WChewale Inc · Beaverton, ORBuilt 1976 · S/N N.C.013

Back to AD 2005-10-13