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.

N4080SCosse John J Jr Trustee · Lenexa, KSBuilt 1975 · S/N D-9728 N4081Pearl Equipment LLC · Bassfield, MSBuilt 2016 · S/N E-4081 N4082BJdj Inc · Mountain Home, ARBuilt 1977 · S/N 77-30850 N4083A4083a LLC · Wilmington, DES/N D-9110 N4084SDavenport Michael · Naperville, ILBuilt 1975 · S/N D-9729 N40855Covey Stephen B · Manvel, TXBuilt 2000 · S/N E-3298 N4085BMarroquin Jesse B DBA · Schertz, TXFirst renewal noticeBuilt 1976 · S/N 76-30821 N4086APippert James R · Dysart, IABuilt 1970 · S/N D-9112 N4086S80'S Associates Inc · Pittstown, NJBuilt 1975 · S/N D-9731 N4089SRaii3 LLC · Lewes, DEBuilt 1975 · S/N D-9732 N408CDKc Jet Sales LLC · Scottsdale, AZBuilt 2005 · S/N 1464 N408JCN408jc LLC · Scottsdale, AZBuilt 1977 · S/N E-1194 N4090ATop Gun Aviation Group Inc · Santa Monica, CABuilt 1978 · S/N 310R1368 N4090SByerly Brooks · Plano, TXBuilt 1975 · S/N E-645 N4091GRobinson Brant Fitzgerald · Powder Springs, GABuilt 1977 · S/N 340A0275 N4091SBeechcraft Heritage Museum · Tullahoma, TNBuilt 1975 · S/N CE-556 N4092TEnnyx LLC · Clermont, FLBuilt 1974 · S/N E-556 N4093EDmkr LLC · Coronado, CABuilt 1999 · S/N E-3293 N4094BClosson Luke E Jr · Valdosta, GABuilt 1975 · S/N 75-30782 N4095AValiair Limited Company Trustee · Casper, WYBuilt 1979 · S/N 18503910 N4099SDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N TE-1037 N409ACHighland Holdings LLC · Bethlehem, PABuilt 1966 · S/N 336 N409BKHyannis Air Service Inc DBA · Hyannis, MABuilt 1982 · S/N 402C0651 N409CDArmbruster LLC · Amherst, OHBuilt 2005 · S/N 1286 N409MFenton Richard O · Weatherford, TXBuilt 1969 · S/N D-8981 N409PValiair Limited Co Trustee · Casper, WYBuilt 2005 · S/N E-3656 N409PDIowa Great Lakes Flyers Inc · Cheyenne, WYBuilt 1973 · S/N CE-450 N409PKSky Cowboy Supply Co LLC · Cape Elizabeth, MEBuilt 1978 · S/N 18503721 N409SJKirsh & Kirsh P C · Indianapolis, INBuilt 2005 · S/N 42084 N409SSBlackwell Aviation Inc · Bell Vernon, PABuilt 1965 · S/N D-7952 N409VRegistered aircraftBuilt 1965 · S/N TE-7 N40ABSchumacher Steven Joseph · Fayetteville, ARBuilt 1983 · S/N CE-1020 N40CFG&M Flyers LLC · Wilmington, DEBuilt 1998 · S/N 29-0136 N40GHagerty Environmental LLC · Kennett Square, PABuilt 1972 · S/N D-9342 N40GBSlb Enterprises LLC · Newark, DEBuilt 1977 · S/N 340A0264 N40GDSimply Living LLC · Fort Myers, FLBuilt 2003 · S/N 0473 N40GMSteven E Cox · Bend, ORBuilt 1964 · S/N D-7343 N40GVHauser Paul J · Longmont, COBuilt 1976 · S/N U20603438 N40JBElk River Aero LLC · Noel, MOS/N TH-338 N40JCDbs Aviation LLC · Sulphur Springs, TXBuilt 1973 · S/N 421B0384 N40JHJohnson Sean M · Martinez, CABuilt 1975 · S/N E-772 N40KGFour Stars Aviation Inc · Mclean, VABuilt 1983 · S/N E-2067 N40KTDemuth Gabriel J · Jackson Springs, NCBuilt 1968 · S/N D-8717 N40MEUnlimited Boat Sales Inc · Page, AZS/N 421C1241 N40MWCarbone Peter E Jr · Hopkinton, MAFirst renewal noticeBuilt 1980 · S/N E-1708 N40NYJohnson Elite International LLC · Tucson, AZBuilt 1970 · S/N 414-0160 N40PGFunanich Jon J Trustee · Fairfield, CABuilt 1980 · S/N TJ-309 N40PMFlypie Industries LLC · Hudson, WIBuilt 1986 · S/N 4608005 N40RUMoore Terry Alexander Trustee · Adel, GABuilt 1980 · S/N 421C0878 N40SKSides Family Management LLC · El Paso, TXBuilt 1979 · S/N 414A0323

Back to AD 86-13-04 R3