Registered aircraft · 18,497

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-13-04-R3') 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-13-04-R3') 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-13-04-R3')
    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-13-04-R3')
  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-13-04-R3')
  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-13-04-R3')
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.

N4366WPrentice Chris · Independence, ORBuilt 1974 · S/N D-9620 N4366ZEse Aviation LLC · Houston, TXBuilt 1984 · S/N 46-8408069 N436ATWheels Up LLC · Aloca, TNBuilt 1978 · S/N TH-953 N436CDSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2005 · S/N 1522 N436DGGetting Dean W · Fort Dodge, IABuilt 1978 · S/N E-1213 N436EButcher Gregory E · Pensacola, FLBuilt 1964 · S/N D-7532 N436EUStevann Farms Ltd · De Witt, IABuilt 2005 · S/N E-3612 N436JB700p LLC · Lewes, DEBuilt 1976 · S/N D-9884 N436MHaase LLC Series 5 · Henderson, NVBuilt 1990 · S/N EA-512 N436RADebon Corp · La Center, WABuilt 1999 · S/N E-3270 N436SN436s LLC · Fernandina Beach, FLBuilt 2007 · S/N E-3776 N4370WHincha Stacie B · Thatcher, AZBuilt 1974 · S/N E-559 N4371WRussell Chris J · Cheyenne, WYBuilt 1974 · S/N CE-501 N4372BTyler Hendry Dds Inc · Glendale, CABuilt 1984 · S/N 46-8408083 N4372EPad Aviation LLC · New Castle, DEBuilt 1984 · S/N 46-8408085 N4372LSteen Douglas S · Cresson, TXBuilt 1984 · S/N 46-8408087 N4374MThursby William T · Cedar Hill, TXBuilt 1979 · S/N E-1589 N4375PShea Roger · Alta, WYBuilt 1985 · S/N 46-8508031 N4375WTouch N Go Aeroworks LLC · Greenville, SCS/N TH-489 N4376APeavy Ricky Tod · Gainesville, GABuilt 1984 · S/N 46-8508004 N4376RMoore Michael J · Mountain Brk, ALBuilt 1969 · S/N CJ-14 N4376WSmith Ryan · Canby, ORBuilt 1974 · S/N D-9626 N4377ATebeaux William Jene · College Station, TXBuilt 1984 · S/N 46-8508008 N4377GD&P Enterprises Inc · Fresno, CABuilt 1985 · S/N TJ-479 N437CWestacott Simon · Fenwick Island, DEBuilt 2002 · S/N 0375 N437EMagic Shuttle Bus Air Tours LLC · Traverse City, MIBuilt 1966 · S/N D-8179 N4380DLivengood Leasing Co LLC · Mesa, AZBuilt 1985 · S/N 46-8508045 N4380S9791m LLC · Tacoma, WABuilt 1984 · S/N 46-8508020 N4380WAtaraxia Aircraft Holdings LLC · Greenville, SCBuilt 1974 · S/N TH-448 N4384TTaw Development Inc · Raleigh, NCBuilt 1984 · S/N 46-8508028 N4384WPacific Media Properties Inc · Santa Ana, CABuilt 1974 · S/N E-536 N4386NFreedom Airplane Jv 1 LLC · Pensacola, FLBuilt 1985 · S/N 46-8508039 N4387DTravel Direct LLC · Montevideo, MNBuilt 1985 · S/N 46-8508040 N4388MMalibu 88mike LLC · Duncanville, TXBuilt 1985 · S/N 46-8508047 N4388WNiezen Henry J · San Luis Obispo, CABuilt 1974 · S/N D-9600 N438APWhiskey 340 LLC · Tucson, AZBuilt 1977 · S/N 340A0438 N438CDSquibb Daniel · Xenia, OHBuilt 2005 · S/N 1404 N438EL1 Stop Sod & Landscaping Inc · Orlando, FLBuilt 1977 · S/N 421C0274 N438GMRye Air LLC · Grimes, IABuilt 2000 · S/N E-3353 N438TBluhm Raymond M · Waxhaw, NCBuilt 1971 · S/N D-9256 N43911Scud Runner LLC · Cape Coral, FLBuilt 1985 · S/N 46-8508059 N4391EN4391e LLC · Scottsdale, AZBuilt 1985 · S/N 46-8508054 N4393AOgilvie Terry Michael · Loveland, COBuilt 1970 · S/N CE-300 N4394WSisson James M · Orlando, FLBuilt 1974 · S/N TH-460 N439NKSt Louis Aircraft Partners LLC · Saint Louis, MOBuilt 2004 · S/N 0919 N439SFCarter Randy C · Poway, CABuilt 1995 · S/N 29-0039 N43AKEarth Center Adventures Inc · Haines, AKBuilt 1980 · S/N U20605545 N43BBHilyer Bruce W · Camano Island, WABuilt 1990 · S/N CE-1517 N43BMDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 421C1224 N43CPMountain View Industries LLC · Missoula, MTBuilt 1979 · S/N P21000398

Back to AD 86-13-04 R3