Registered aircraft · 18,495

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.

N90575Benschoter Cameron Paulk · Jonesboro, GAFirst renewal noticeBuilt 1948 · S/N D-1848 N9057SMedical Supply X LLC · Coats, NCS/N 21065009 N9058QHeffley Lynn · Pottsboro, TXBuilt 1970 · S/N TH-95 N905ATWagner Kendall · Yorba Linda, CABuilt 1991 · S/N E2632 N905BWMauro William J · Lancaster, CABuilt 1968 · S/N 21059033 N905ETDawson Richard E · Green Valley, AZS/N 148 N905MAHigh Flight LLC · Casey, ILBuilt 1997 · S/N 29-0105 N905PCLamb Robert Duncan · Kiln, MSBuilt 2003 · S/N 42026 N905VPratt Raymond P · Sandia Park, NMBuilt 1974 · S/N D-9635 N9063MThompson Anthony · Miami, FLBuilt 1971 · S/N 402B-0105 N90659Jones Thomas J · Casper, WYBuilt 1973 · S/N D9437 N9066SPower Flow Systems Inc · Daytona Beach, FLBuilt 1978 · S/N E-1305 N9067QBrabeck Mark F · Glasgow, MTBuilt 1970 · S/N D-9200 N9068QPursell Robert W · Las Vegas, NVBuilt 1970 · S/N D-9199 N9068RHrabe Dusten · Chamberlain, SDBuilt 1975 · S/N 18802095T N906CDHiggins Mechanical Inc · Gardner, MABuilt 2003 · S/N 0523 N906RDCollareno Kevin A · Northville, MIBuilt 2005 · S/N 1264 N906RSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1965 · S/N 21058625 N906VState Of Alabama · Montgomery, ALBuilt 1974 · S/N TE-983 N9070SFontana Brent S · Rogers, ARBuilt 1978 · S/N CE-793 N9072SSaddleback Enterprises LLC · Newport Beach, CABuilt 1978 · S/N E-1307 N9074QDulin Michael N · Edmond, OKBuilt 1970 · S/N E-235 N9075QBenson Edward A · San Antonio, TXBuilt 1970 · S/N D-9202 N9076Q76q LLC · Ventura, CABuilt 1970 · S/N E-236 N9079HJoey Os LLC · Darlington, PABuilt 1979 · S/N 21063829 N907AKErickson Michael J Jr · Juneau, AKBuilt 1993 · S/N 18502297 N907CAllen Gavin Alton · Bloomfield, CTBuilt 2002 · S/N 0385 N907CDGullapalli Vamsi K · Sartell, MNBuilt 2005 · S/N 1706 N907CERoss Peter W Trustee · Lufkin, TXBuilt 1976 · S/N 18503081 N907DRWhite Warren R · Birmingham, ALBuilt 2005 · S/N 1300 N907JMWright Flight Inc · Tucson, AZS/N 21063665 N907LMDe Gavere Lambert M · Anchorage, AKBuilt 1974 · S/N 18502372 N9080XNoldin John · Griffith, INS/N 46-8608035 N9081QReplogle Randall B · Gulfport, MSBuilt 1970 · S/N D-9203 N9083HNewton Aero LLC · Hurdland, MOBuilt 1974 · S/N 18801829T N9083RStuder Alfred C · Shelby, MIBuilt 1975 · S/N 18802104T N9083SRobinson Charley C · Guthrie, OKBuilt 1978 · S/N TJ-152 N9083UNashville Malibu Partners LLC · Hendersonville, TNBuilt 1986 · S/N 46-8608039 N9083ZCalder Brothers Corp · Greenville, SCBuilt 1986 · S/N 4608003 N9084QEanes Thomas M · Fort Worth, TXBuilt 1970 · S/N E-237 N9086SKats Ventures LLC · Byron, MNBuilt 1978 · S/N CE-790 N908ATWegener Airlines Inc · Ridgeland, MSBuilt 1991 · S/N E2639 N908DBB36 LLC · Winter Park, FLBuilt 2002 · S/N EA-694 N908JQualitair LLC Trustee · MichelstadtBuilt 2010 · S/N TH-2288 N908PScott Kevin · Santa Fe, NMBuilt 2000 · S/N EA-664 N908VSeven M Enterprises LLC · Kalispell, MTBuilt 1974 · S/N D9645 N908ZUAyers John C · Narragansett, RIBuilt 2004 · S/N 1040 N9090JDieppa Pablo F · North Charleston, SCBuilt 1986 · S/N 46-8608049 N9090NPmt Flyers LLC · Amarillo, TXFirst renewal noticeBuilt 1986 · S/N 46-8608050 N9093QInvesta Aviation LLC · Yoakum, TXBuilt 1971 · S/N E-296

Back to AD 86-13-04 R3