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.

N51FDH2f2 LLC · Prairie Village, KSBuilt 1979 · S/N TH-1075 N51HAJd Air Inc · Fairlawn, NJBuilt 2014 · S/N TH-2418 N51HMDw Peterson Inc · Warren, MNBuilt 1966 · S/N D-8288 N51MAAch Construction & Properties LLC · Mount Pleasant, TXBuilt 1978 · S/N E-1230 N51MLTrek Aviation LLC · Amsterdam, NYBuilt 1997 · S/N E-3105 N51PVCrupi John · Fort Lauderdale, FLBuilt 1987 · S/N CE-1174 N51QZAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1982 · S/N 421C1237 N51SARedtail Partners LLC · Moab, UTBuilt 1981 · S/N 20700699 N51WAPennewell Solutions LLC · Dover, DEBuilt 1973 · S/N CE-452 N52004Jones Steve M · Anchorage, AKBuilt 1974 · S/N 18052437 N5200QBas Part Sales LLC · Greeley, COBuilt 1969 · S/N 21059130 N5200XRwr Air Inc · Tok, AKBuilt 1980 · S/N U20605591 N5201ADan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1979 · S/N 21063305 N5203AGv Air Inc · Medford, ORBuilt 1979 · S/N 21063306 N5203UHusted Robert P · Byers, COBuilt 1964 · S/N 206-0203 N5203XMike & Critter LLC · Mccall, IDBuilt 1980 · S/N U20605592 N5206UMudminers LLC · Wasilla, AKBuilt 1964 · S/N 206-0206 N5209COlson Alan G · New London, MNBuilt 1979 · S/N 21063716 N5209JDallas Aero & Sales LLC · Poplar, MTBuilt 1977 · S/N 310R1000 N520ABGolden Eagle Transportation LLC · Lafayette, LABuilt 1979 · S/N 421C0690 N520BCMitchell Bruce P · Medford, ORBuilt 2004 · S/N 0996 N520DGrimes Brian T · Kingman, AZBuilt 2008 · S/N 051SR N520KWWood Stephen J · Winthrop, MEBuilt 1970 · S/N 18501825 N520LWalker Dale A Jr · Limon, COBuilt 2004 · S/N L2K-140 N520LLMesoamerica Aviation Corp · Wilmington, DEBuilt 2002 · S/N TH-2052 N520PKJol Av Inc · Orange Beach, ALBuilt 2000 · S/N E-3365 N520TStanton Thomas M · Mcallen, TXBuilt 1966 · S/N TE-63 N520VASale Reported · Pleasant Grove, CASale reported, pending cancellationBuilt 1977 · S/N 18503352 N520XXTrevisan Hugo S · Polk City, FLS/N 1 N520YHTurnbull Timothy H · Mccall, IDBuilt 1978 · S/N 18503619 N5211JTdm Aviation LLC · Huntsville, ALBuilt 1976 · S/N 310R0806 N5211KP-Factor LLC · Titusville, FLBuilt 1950 · S/N NAV-4-2111D N5217CHydro Wings Inc · Valle Crucis, NCBuilt 1979 · S/N 21063719 N5217ERamsey Thomas R · West Bath, MES/N 18503941 N5217UKelly Colby R · Anchorage, AKBuilt 1964 · S/N 206-0217 N5217VScrobola Air LLC · Wyoming, PABuilt 1975 · S/N 21060863 N521ADBarringer Aviation LLC · Waxhaw, NCBuilt 1977 · S/N 310R0966 N521BTBennett Brady R · Pinehurst, NCBuilt 2003 · S/N 0752 N521BWBilmar Avionics Inc · Kissimmee, FLBuilt 1974 · S/N 21060297 N521CRuhan Brendon Thomas · Rehoboth, MABuilt 1987 · S/N CE-1119 N521EAngels Ten LLC · Norfolk, VABuilt 1981 · S/N CE-963 N521JCRasmussen Group · Des Moines, IABuilt 2008 · S/N TH-2242 N521KMMcmorries Kyle P · Nacogdoches, TXBuilt 1984 · S/N 21064868 N521MMEagle Topflight LLC · Cape Girardeau, MOBuilt 1988 · S/N 4608104 N521PWDoghouse Aviation LLC · Vienna, VABuilt 1988 · S/N E-2434 N521SCHarrison Ted W · Grapevine, TXBuilt 1977 · S/N 21062343 N521SGPerfect Landing Aviation LLC · Highlands Ranch, COS/N 29-0362 N521VRMyers Jonathan A · Dieterich, ILBuilt 1965 · S/N D-7922 N521WSCmt Properties LLC · Laurel, MSBuilt 1997 · S/N TH-1836 N521ZHoffner Flying Inc · Yankton, SDBuilt 2002 · S/N 0176

Back to AD 86-13-04 R3