Registered aircraft · 18,498

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.

N167TFWhitney David W · Ooltewah, TNBuilt 1967 · S/N D-8472 N167TRBarton Aviation LLC · San Antonio, TXBuilt 1998 · S/N TH-1849 N167WAGrid Aero Inc · San Leandro, CABuilt 1976 · S/N 402B1044 N1681UMeise Bill · Spring Green, WIBuilt 1982 · S/N 21064725 N1684WHaller Philip L · Peoria, AZS/N D-9386 N1686MTerrastar LLC · Kalispell, MTBuilt 1971 · S/N 18501873 N1687WAirway Management Inc · Wilmington, DEBuilt 1972 · S/N E-355 N1687XMorton Douglas E · Cody, WYBuilt 1975 · S/N 21060722 N1688WDjm Investments Inc · Menno, SDBuilt 1972 · S/N D-9388 N168CCLanham Aviation LLC · Simpsonville, KYBuilt 1990 · S/N TH-1606 N168EDTsg Aviation LLC · Wyandotte, MIBuilt 1975 · S/N 310R0134 N168GGWisconsin Aviation Inc · Watertown, WIBuilt 1979 · S/N 414A0304 N168JGFlymore LLC · New City, NYBuilt 1999 · S/N E-3253 N168LLSteve Jackson Racing LLC · Helena, MTBuilt 2014 · S/N L2K-168 N168MNelson Lars C · Anchorage, AKBuilt 1968 · S/N D-8762 N168NLLakeside Views LLC · La Crescenta, CABuilt 1966 · S/N CE-45 N168SABruchid Snodgrass LLC · Reno, NVBuilt 1981 · S/N U20606073 N168SDCometenterprises.Net LLC · Kalispell, MTBuilt 1979 · S/N P21000460 N168ULeading Edge LLC · Scottsdale, AZBuilt 1969 · S/N D-8986 N168WACharles Michel · St Thomas, VIBuilt 1984 · S/N 402C0808 N1690RFederal Aerial Applicators LLC · Wilmington, DEBuilt 1974 · S/N 18502413 N1690WHarran Patrick · Santa Monica, CABuilt 1972 · S/N D-9391 N1692MClark Shawn W · Anchorage, AKBuilt 1971 · S/N 18501877 N1693WAntique Endeavors LLC · Missoula, MTBuilt 1972 · S/N D-9389 N1694MWraith Lane T · Wasilla, AKS/N 18501879 N1694RCrow Rock LLC · Stillwater, MNBuilt 1974 · S/N 18502417 N1694WKlauber James S Sr · Boonsboro, MDBuilt 1972 · S/N E-363 N1695WVon Seggern Robert J · Chesterfield, MOBuilt 1972 · S/N D-9393 N1696XCenturion LLC · New Bern, NCBuilt 1975 · S/N 21060731 N1697WMountcastle Creek LLC · Pratt, KSBuilt 1972 · S/N E-365 N1698WLawrence John · Dayton, NVBuilt 1972 · S/N D-9392 N1698XCmo Blue Sky LLC · Tomball, TXS/N 21060733 N1699WDkp Holdings LLC · Melbourne Beach, FLBuilt 1973 · S/N E-399 N169BZTailhook Industries LLC · Chandler, AZBuilt 2006 · S/N L2K-241 N169DKStanton James · North Barrington, ILBuilt 1978 · S/N 310R1412 N169DWA&P Properties LLC · Manns Choice, PABuilt 2005 · S/N 1523 N169GRBlue Skies Above LLC · Spring, TXBuilt 1995 · S/N EA-580 N169HWood Wendell · Holland, TXBuilt 2001 · S/N 29-0264 N169JMBravo Alpha LLC · Driggs, IDBuilt 1978 · S/N P21000169 N169KSSvetfur Aviation LLC · Camden, SCBuilt 1978 · S/N 414A0015 N169LALee Arnold Management Services Inc · Clearwater, FLBuilt 2017 · S/N TH-2494 N169PGHarty Joshua · Strasburg, COS/N T210-0423 N169RRGerlach & Associates LLC · Valparaiso, INBuilt 1979 · S/N TH-999 N16ASStefenelli Aviation N Tr Inc Trustee · AtterseeBuilt 1973 · S/N 421B0317 N16AWFreas Joseph R · Simi Valley, CABuilt 1973 · S/N 74-30634 N16AXKing Austin · Abilene, TXBuilt 1980 · S/N 21064101 N16BKWc Aviation LLC · Forest, VABuilt 2012 · S/N TH-2335 N16CJRoyale Air Service Inc · Fort Myers, FLS/N U20602501 N16DADonaire Aviation LLC · Tampa, FLBuilt 1974 · S/N TH-501 N16EZAmerican Aerial Survey Inc · Rancho Murieta, CABuilt 1978 · S/N 310R1277

Back to AD 86-13-04 R3