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.

N2875WTreadway Ag Delaware LLC · Lewes, DES/N D-9508 N287HHaught Herbie B Jr · Mountain View, ARBuilt 1965 · S/N D-7763 N287KMO'Connor Thomas F · Plano, TXBuilt 1980 · S/N TJ-330 N287LMDjc Bonanza LLC · Stuart, FLBuilt 1994 · S/N E-2859 N287TASivad Holdings Corp · Nacogdoches, TXBuilt 2025 · S/N 087/US N2882WWholey James · Saratoga, CABuilt 1973 · S/N E-452 N28835Waddingham William B · Rancho Cucamonga, CABuilt 1969 · S/N 421A-0050 N2886WBushong Chistopher L · Gulf Shores, ALS/N D-9512 N288FGroove LLC · Afton, VABuilt 1965 · S/N D-7970 N288MTgc Aviation LLC · Watkinsville, GABuilt 2002 · S/N E-3460 N288PBlue Water Aviation Inc · Jupiter, FLBuilt 1980 · S/N TH-1113 N288SVMartin Terry L II · De Soto, MOBuilt 1995 · S/N 95-301022 N288TATurbine Time LLC · Mercer Island, WABuilt 1999 · S/N TH-1926 N2890WAlbatross Aviation LLC · Lakeville, OHBuilt 1973 · S/N D-9510 N28913Bellas Business LLC · Kalispell, MTBuilt 1973 · S/N 340-0153 N2894WDavenport Skyler R · Granbury, TXBuilt 1973 · S/N D-9514 N2895WN2895w LLC · Mount Airy, MDBuilt 1973 · S/N E-457 N289SBHemcka Aviation LLC · Bradenton, FLBuilt 2004 · S/N 1102 N28APAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 1978 · S/N 414A0204 N28BRFlying Rock Aero LLC · Sunnyvale, CABuilt 1986 · S/N 468608045 N28CCGulf Airbatics Ltd · Jennings, LABuilt 1979 · S/N 414A0226 N28CNRoman Stephen B · Minnetrista, MNBuilt 1976 · S/N CN-1 N28CPArk Investments Inc · Ridgeland, MSBuilt 1971 · S/N D-9213 N28DBEdson Franz R · Waterford, CTBuilt 1970 · S/N D-9139 N28DJMccrorie David M · Port Angeles, WABuilt 1964 · S/N D-7320 N28FXSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N TH-2126 N28JEWallace Coke W · Healy, AKS/N 18502911 N28JMWestern Aviation Services LLC · Cheyenne, WYBuilt 1979 · S/N P21000431 N28KYSoldo Joseph Peter · Chattanooga, TNBuilt 1984 · S/N 468508015 N28LDDancing Bear LLC · Polson, MTBuilt 1970 · S/N D-9205 N28LVCactus Clover Inc · El Paso, TXBuilt 1979 · S/N 340A0754 N28MGHudson Equipment LLC · Camden, DEBuilt 1988 · S/N TH-1535 N28NTHammock Flying Service Inc · Black Rock, ARBuilt 1975 · S/N 310R0243 N28PCGriesman Scott W · Sandy Valley, NVBuilt 1967 · S/N 377 N28RHNational Airplane Sales & Leasing Corp · Lima, OHBuilt 1980 · S/N 421C0847 N28RSElohim Airparts Sales LLC · Naples, FLBuilt 1970 · S/N 21059316 N28WBMulder Air Inc · Renville, MNBuilt 1968 · S/N D-8729 N28WDOptio Air LLC · Moore, OKS/N 421C0715 N29000Bevins William Brian · Phoenix, AZBuilt 1967 · S/N U206-1000 N29002E A B Services LLC · Cape Coral, FLBuilt 1972 · S/N 21059777 N29003R J Kielty Plumbing Heating And Cooling Inc · New Port Richey, FLS/N 21059778 N2900TEwing Richard Jr · Antelope, CABuilt 1966 · S/N 301 N29018Pacific Rim Energy Inc · Henderson, NVBuilt 1967 · S/N U206-1014 N2901LStraight & Level Aviation LLC · Bradenton, FLBuilt 1980 · S/N TH-1172 N2902N2902 LLC · Miami, FLBuilt 1977 · S/N U20603637 N29022Unifly Inc · Lackawanna, NYBuilt 1972 · S/N 21059783 N2902QHeihn Daniel M · Soldotna, AKS/N 18503539 N2902THarber Gary · Melbourne, FLBuilt 1966 · S/N 303 N2902VArnold Thomas E · Casper, WYBuilt 1947 · S/N 118 N2903QTwin Fiddle Investment Aeronautics LLC · Atlanta, GABuilt 1978 · S/N 18503540

Back to AD 86-13-04 R3