Registered aircraft · 623

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:86-20-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:86-20-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:86-20-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:86-20-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:86-20-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:86-20-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.

N35KHBlackbell 22 LLC · Wilmington, DEBuilt 2024 · S/N 0355FF N35NRCentral States Helicopters Inc · Wood River, NEBuilt 1995 · S/N 52137 N361ALBillings Flying Service LLC · Billings, MTBuilt 1987 · S/N 51212 N361DT925dt LLC · Picayune, MSBuilt 1994 · S/N 52080 N361SHLima Whiskey LLC · Missoula, MTBuilt 1989 · S/N 0058FF N362ALMarks Lloyd · Lafayette, LABuilt 1991 · S/N 51471 N367PDCity Of Atlanta · Atlanta, GABuilt 2023 · S/N 0344FF N369FFBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 0709FF N369TVTennessee Valley Authority · Muscle Shoals, ALBuilt 2017 · S/N 0269FF N36FGCalifornia Department Of Fish & Wildlife · Sacramento, CABuilt 2020 · S/N 0322FF N370DPDodson International Parts Inc · Rantoul, KSBuilt 1992 · S/N 51569 N371PDCity Of Atlanta · Atlanta, GABuilt 2023 · S/N 0345FF N3777MRotor Co · New Braunfels, TXBuilt 1991 · S/N 51485 N377LFHelicopter Parts International Inc · Minden, NVBuilt 1989 · S/N 51281 N378JCLongranger IV LLC · Missoula, MTBuilt 2013 · S/N 52448 N383SHAspen Helicopters Inc · Oxnard, CABuilt 1983 · S/N 51073 N385RLSan Juan Aviation LLC · Wilmington, DEBuilt 2008 · S/N 52385 N386VCCounty Of Volusia · Deland, FLBuilt 1996 · S/N 52179 N388JCSweetwater Landing LLC · Helena, MTBuilt 1981 · S/N 45568 N3893UMonarch Enterprises Inc · Kirkland, WAS/N 51020 N3895DMonarch Enterprises Inc · Kirkland, WABuilt 1980 · S/N 45590 N38BZHelicopters Inc · Wilmington, DEBuilt 1995 · S/N 52128 N38THGlobal Aerials Inc · Pembroke Pines, FLS/N 45653 N395AEAir Evac Ems Inc · O Fallon, MOS/N 45551 N396RLMorris Equipment LLC · Yuma, AZBuilt 1980 · S/N 45-396 N397RLBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N 45397 N399AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 52490 N399MHBlade Leasing LLC · Homer, AKBuilt 1993 · S/N 52016 N39LRHornet LLC · Picayune, MSBuilt 1981 · S/N 45654 N3QYHelicopters Inc · Wilmington, DEBuilt 1999 · S/N 52224 N401FNNy On Air LLC · Kearny, NJBuilt 1994 · S/N 52081 N401FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLFirst renewal noticeBuilt 2006 · S/N 52327 N40290Haddock Flying Service Inc · Salters, SCBuilt 1980 · S/N HA3081 N402AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52393 N402FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLFirst renewal noticeBuilt 2006 · S/N 52328 N402TDAir Metro Helicopters Inc · New City, NYBuilt 1990 · S/N 51383 N4032YBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 5180 N404AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52434 N404MPIndustrial Helicopters LLC · Lafayette, LABuilt 1994 · S/N 52083 N405LPGm Leasing Co LLC · Broussard, LABuilt 1994 · S/N 52085 N405RLGlobal Aviation Florida LLC · Pompano Beach, FLBuilt 1990 · S/N 51405 N4068GGulf Coast Helicopters Inc · Pearland, TXBuilt 1968 · S/N 229 N406KKKehler Kelly · Saint Xavier, MTBuilt 2004 · S/N 52283 N406MPGm Leasing Co LLC · Broussard, LABuilt 1994 · S/N 52086 N406WHHeli-Works Flight Services LLC · Deer Lodge, MTBuilt 1991 · S/N 51537 N407AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52409 N407CCCounty Of Contra Costa · Martinez, CAFirst renewal noticeBuilt 1997 · S/N 53090 N407CHClassic Medical Inc · North Salt Lake, UTBuilt 1996 · S/N 53011 N407FCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 1996 · S/N 53050 N407UTMed Trans Corp · Denton, TXBuilt 1996 · S/N 53036

Back to AD 86-20-13