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.

N5428UCordova Air Service Inc · Cordova, AKBuilt 1979 · S/N U20605290 N542CGulf States Financial Services · Lafayette, LAS/N 21063919 N542CDStorch David · Goodyear, AZBuilt 2004 · S/N 1186 N542DSFox James R DBA · Saint Paul, MNBuilt 1966 · S/N D-8048 N542EBSvoboda Erik S · Mentor, OHBuilt 1981 · S/N 21064351 N542EMRw Air LLC · Boerne, TXBuilt 1980 · S/N P21000581 N542MNKeeler Aviation LLC · Plattsmouth, NEFirst renewal noticeBuilt 1976 · S/N 340A0109 N5430AAdams Hay Farms LLC · Cedar City, UTBuilt 1979 · S/N 21063433 N5431UBrown David G · Knoxville, TNBuilt 1967 · S/N D-8515 N5432JSouthampton Wing LLC · Southampton, NYBuilt 1976 · S/N 340A0110 N5432MWorthington Loren D · Caldwell, IDBuilt 1972 · S/N 340-0033 N5433UHynes Kevin P · Wichita Falls, TXBuilt 1967 · S/N D-8512 N5433XMk Air LLC · Lewistown, MTBuilt 1980 · S/N U20605749 N5434ASteele Group Insurance Agency Inc · Eugene, ORBuilt 1979 · S/N 21063436 N5434UVance Daniel · Bend, ORBuilt 1967 · S/N D-8520 N5436AJls Investments Inc · Lafayette, LAS/N 21063437 N5436UNewsom William Joel III · Roswell, GAS/N 21064892 N5437UBatdorf Richard E · Naples, FLBuilt 1967 · S/N TE-406 N5439CLopez Hugo E · Mcallen, TXFirst renewal noticeBuilt 1979 · S/N 21063755 N543BCRoeloffs Arie · Wendell, IDBuilt 1973 · S/N 414-0474 N543DGrantham Ray · Sevierville, TNBuilt 1984 · S/N 340A1805 N543DGGavora Daniel E · Fairbanks, AKBuilt 1976 · S/N 18503157 N543EMPacific Air Flight School LLC · Long Beach, CABuilt 1978 · S/N 21063054 N543RBBaron Aviation LLC · Calera, ALBuilt 2000 · S/N TH-1953 N543SKGreene Scott P · El Paso, TXBuilt 2004 · S/N 1213 N543VWich Robert · Norfolk, VABuilt 1995 · S/N EA-581 N5442UMorisseau Walner · Tampa, FLBuilt 1967 · S/N D-8516 N5443JKg&C Investment LLC · Saint Charles, ILBuilt 1975 · S/N 421B0901 N5444UBooze Gregory Trustee · Punta Gorda, FLBuilt 1967 · S/N D-8518 N5446GCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1979 · S/N 340A0685 N5447ASchmidt Aaron B · Auburn, ALBuilt 1985 · S/N P21000855 N5447UFly Boston Bailey LLC · Gilbert, AZBuilt 1967 · S/N CE-162 N5448JInfinity Aviators LLC · Scottsdale, AZBuilt 1975 · S/N 421B0906 N5448RBuby Lloyd F · Mannington, WVBuilt 1965 · S/N 17253001 N544CDAeroplanes LLC · Cary, NCBuilt 2005 · S/N 1544 N544GL In The Sky LLC · Horseshoe Bay, TXBuilt 2011 · S/N E-3947 N544MTrim Tab LLC · Fort Collins, COS/N CE-104 N544STGordon Jonathan · Bronxville, NYBuilt 1969 · S/N CJ-22 N544VIngle Maurice O III · Claremore, OKBuilt 1965 · S/N D-7904 N5450UStay Air Borne LLC · Wilmington, DEBuilt 1967 · S/N D-8529 N5451UHeijmans Michael L · Port Orange, FLBuilt 1967 · S/N CE-164 N5451VParker James C · Cuthbert, GABuilt 1975 · S/N 21060952 N5453JC L Flight Associates LLC · Bakersfield, CAS/N 340A0111 N5454XKair Aviation · Parkland, FLS/N 340A1512 N5456YWings As Eagles LLC · Wilmington, DES/N 21064211 N5457AGoebel Joseph · Palos Verdes Est, CABuilt 1985 · S/N P21000856 N545CDValiair Lc Trustee · Casper, WYBuilt 2005 · S/N 1508 N545CP545 Charlie Papa LLC · Colorado Springs, COBuilt 2005 · S/N 1462 N545DHaskell Corporation · Bellingham, WABuilt 1985 · S/N U20606892 N545FAJb Aircraft LLC · Anchorage, AKBuilt 1980 · S/N 20700592

Back to AD 86-13-04 R3