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.

N422MMBolt Robert S · Tampa, FLBuilt 1998 · S/N E-3217 N422PJCra Aviation LLC · Dickerson, MDBuilt 1981 · S/N 421C-1038 N422RKGulf Coast Aerial Mapping Co Inc · Gonzales, LABuilt 1979 · S/N U20605347 N422SSInternational Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N 29-0339 N422SWLarson Daniel · Mora, MNBuilt 1977 · S/N 21062164 N4232QRamstad Trygg J · Anchorage, AKS/N 18502227 N4235CColville LLC · Signal Mountain, TNBuilt 1974 · S/N 414-0534 N4236QTyrrell Jerry R · Woodland, WABuilt 1973 · S/N 18502228 N4237CBreakaway Group Aviation LLC · Franklin, TNBuilt 1974 · S/N 414-0535 N423BWFehring William · Sunnyvale, CABuilt 2000 · S/N EA-658 N423CDGrzebik Ellerine P · Petaluma, CAS/N 1109 N423CLTmt Aero Inc · Perrysburg, OHBuilt 1983 · S/N TH1394 N423JKKraft John · Lake View, IABuilt 1982 · S/N E1951 N423MDSublett Charles M · Tulsa, OKBuilt 1964 · S/N D-7454 N423PPrestige Worldwyde! LLC · Concord Township, OHBuilt 2002 · S/N E 3439 N423RBAdams Aviation Services Inc Owner Trustee · Wilmington, DEBuilt 1981 · S/N 340A1270 N423RGSchue Gary C · Fredericksburg, VABuilt 2005 · S/N SES-181MB2 N423TMJp Aviation Leasing LLC · Salt Lake City, UTBuilt 1976 · S/N 421C-0107 N423WTCoons John K · Winston Salem, NCBuilt 1964 · S/N D-7426 N4241BBor-It Mfg Co Inc · Ashland, OHBuilt 1974 · S/N 75-30727 N4243B43 Bravo LLC · Maple Grove, MNBuilt 1974 · S/N 74-30724 N4245AMac Flight LLC · Conway, ARBuilt 1970 · S/N D-9126 N424ADSky West Aviation Inc Trustee · Albuquerque, NMS/N 20700337 N424BDBadass Aviation LLC · Fernandina, FLBuilt 2005 · S/N 1723 N424CHFlying Betty LLC · Prescott, AZBuilt 2000 · S/N 40004 N424EGS&R Flying LLC · Franklin, TNBuilt 2004 · S/N 0887 N424JN424 Juliet LLC · Mesa, AZBuilt 1984 · S/N 46-8408019 N424JBJsj Aircraft Holdings LLC · San Diego, CAS/N CE-1363 N424LLLarkin Michael Paul · Port Orange, FLBuilt 2006 · S/N L2K-268 N424MEKfl LLC · Canyon Country, CABuilt 1976 · S/N 340A0051 N424PCMontana Livestock Ag Credit Inc · Helena, MTS/N 340A1266 N424QLj Sutter Aviation LLC · Shavertown, PABuilt 1990 · S/N TH-1582 N4255STeton River Flying Service Inc · Rexburg, IDBuilt 1976 · S/N TK-35 N4257ST&S Proch Investments LLC · Harrisonville, MOBuilt 1976 · S/N E-939 N4258CSonrise Aviation LLC · Portland, INBuilt 1978 · S/N 310R1386 N425BBGarcia Robert Lee · Horseshoe Bay, TXBuilt 1968 · S/N 30099 N425CDDtn Aviation LLC · Winona, MNBuilt 2004 · S/N 0892 N425MGGrinnan Michael · Stafford, VAS/N D-7813 N425MSMcdonald Shane · Belmont, MSBuilt 2005 · S/N 1256 N425PQuimus Aviation LLC · Townsend, WIBuilt 1998 · S/N E-3175 N42609Jcr Ag LLC · Frederick, OKBuilt 1980 · S/N 18803666 N4262SPeck Crosby S · Meredith, NHS/N E-942 N4264CMmc Properties LLC · Cottonwood, AZBuilt 1978 · S/N 340A0516 N4264JBellamy Mark A · Freeville, NYBuilt 1975 · S/N 310R0201 N426ASSaylor Alvin N Jr · Friendswood, TXBuilt 1970 · S/N P206-0590 N426DDRare Air Aviation Services LLC · Santa Rosa, CABuilt 1970 · S/N TH-93 N426LJVenture Air Solutions Inc · Opa Locka, FLBuilt 1981 · S/N 402C0434 N426PTWinter Livestock · Dodge City, KSBuilt 2007 · S/N E-3783 N426TWTubb J Scott · Farmington, NMBuilt 2015 · S/N E-4077 N426WULucy In The Sky LLC · Los Angeles, CABuilt 2005 · S/N 29-0340

Back to AD 86-13-04 R3