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.

N40SSAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1979 · S/N 340A0650 N40TEWild Warbirds LLC · Uvalde, TXS/N CE577 N40TRKwong Elwood · Foothill Ranch, CABuilt 1977 · S/N E-1190 N40VKelly Donald William Jr · Roswell, GABuilt 1971 · S/N TE-799 N40XSSasser F Michael · Cedar Park, TXBuilt 1978 · S/N E-1278 N41019Sjs Flights Lp · Columbus, GABuilt 1973 · S/N 421B0401 N4101PKnepp Terry Wayne · Montgomery, INBuilt 1977 · S/N E-1026 N4102LWiplinger Robert D · Inver Grove Height, MNBuilt 1973 · S/N U20602093 N4102SFlying Drahthaar LLC · Billings, MTBuilt 1975 · S/N TE-1038 N4103SSky High Aviation LLC · Fishers, INBuilt 1975 · S/N TE-1039 N41041Mathews Christopher D · Blue Earth, MNBuilt 1973 · S/N 421B0412 N4104SSky West Aviation Inc Trustee · Albuquerque, NMS/N CE-558 N4104T4a Legacy Enterprises LLC · Mcallen, TXBuilt 2001 · S/N E-3411 N41055J&B Aircraft LLC · Anaheim, CABuilt 1974 · S/N 421B0576 N4106SCompnet Solutions Inc · Dallas, TXBuilt 1975 · S/N CE-559 N4107SAnnamar LLC · Wilmington, DEBuilt 1975 · S/N D-9735 N41085421 Bravo LLC · Marine City, MIS/N 421B0440 N4108GKimberk Frederick S · Cambridge, MABuilt 1971 · S/N TH-166 N4108SBto Aviation LLC · Eden Prairie, MNBuilt 1975 · S/N TH-605 N4109BMccowan Joseph F · Sylvania, OHBuilt 1974 · S/N 75-30760 N410ABBloxsom Allan P III · Boerne, TXBuilt 1979 · S/N P21000352 N410DRJmsat Corp · Moneta, VABuilt 1977 · S/N TK52 N410ECSoutheast Enterprises LLC · Dothan, ALBuilt 1973 · S/N 421B0422 N410HAWalega Jane Ellen · Essex, MDBuilt 1982 · S/N E-2035 N410JCFbn Holding Corp · Larkspur, CABuilt 1986 · S/N 4608038 N410LJBednar David · Norwalk, IABuilt 1982 · S/N EA293 N410NFMurphy Aviation Inc · Gilroy, CABuilt 1978 · S/N 414A0102 N410PCBohnert Matthew · Bend, ORBuilt 1976 · S/N TJ-48 N410PKEnergy And Environment LLC · Fayette, MES/N 18503358 N410RWButler National Inc · New Century, KSBuilt 1982 · S/N E-2031 N410T410t LLC · Kennett Square, PABuilt 1988 · S/N CE-1239 N410TWRice Dwight L · Borger, TXBuilt 2008 · S/N 411044 N410WMFlying Life LLC · Middleburg, FLBuilt 1975 · S/N 310R0578 N41106Delorenz Robert J · Boca Raton, FLBuilt 1974 · S/N 421B0589 N41114Iacobacci Timothy R · Fairborn, OHBuilt 1973 · S/N 421B0458 N4111SKnowles Warren R · Ocean City, NJS/N TJ-4 N4112Feltmann Dean A · North Charleston, SCBuilt 1966 · S/N TE-159 N41124Wenta Nip & Sanitizing LLC · Monte Vista, COBuilt 1973 · S/N 421B0465 N4114SHeffernan Duane C · Moravia, NYS/N CE-434 N4115SDanielson Adam M · Chassell, MIS/N TH-644 N4116GAcaats LLC · Queen Creek, AZBuilt 1977 · S/N 340A0288 N4118SStevens Ronald D · Boise, IDFirst renewal noticeBuilt 1975 · S/N CE-563 N411AArnold Aviation & Thunder Mountain Express Inc · Cascade, IDBuilt 1979 · S/N 18503748 N411ABAmerican Time Machine LLC · Edmond, OKBuilt 1980 · S/N 414A0524 N411DCWillert Fred J · San Diego, CABuilt 1965 · S/N 411-0135 N411EHeli Thrills LLC · Wills Point, TXBuilt 1968 · S/N E-24 N411GTTeam 646 LLC · Jupiter, FLBuilt 2005 · S/N 1714 N411HZCedar Dix LLC · Lancaster, KYBuilt 2005 · S/N 1568 N411JGKern County Aviation Leasing LLC · Bakersfield, CABuilt 1986 · S/N EA-461 N411LNathan David L DBA · Fullerton, NEBuilt 1974 · S/N TE-976

Back to AD 86-13-04 R3