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.

N996FInloes Mechanical Utah LLC · Ogden, UTBuilt 1996 · S/N E-3042 N996JKFletcher Flying Service 419 LLC · Labelle, FLBuilt 1996 · S/N E-3051 N996VWakeman Donald H · Hanover, NHBuilt 1980 · S/N E-1654 N9970ZHartland Aviation LLC · Hartland, MIBuilt 1983 · S/N U20606783 N9974MAllmen David B · Valley Center, CABuilt 1978 · S/N U20604624 N9976MBrush Wesley A · Sparks, NVBuilt 1978 · S/N U20604626 N9977JBoening Bros Dusting & Spraying Inc · Floresville, TXBuilt 1982 · S/N T18803906T N997AKLake Clark Air Inc · Port Alsworth, AKBuilt 1969 · S/N 20700019 N997BBBlankenship John R · Weirsdale, FLBuilt 1980 · S/N D-10328 N997BC997bc LLC · Roseburg, ORS/N D-7761 N997CDN997cd Corp Trustee · Wilmington, DEBuilt 2004 · S/N 0893 N997CHHolly Ridge Planting · Indianola, MSBuilt 1986 · S/N T21064997 N997JS & C Aero LLC · Collierville, TNBuilt 1974 · S/N CE-498 N997JDAviation.One Business Holdings LLC · Mesa, AZBuilt 1984 · S/N 414A1004 N997LPNiner Seven Lima Papa Corp · Wilmington, DEBuilt 1999 · S/N ES-066-FB N997RRegistered aircraftBuilt 1974 · S/N 21060386 N997TAAir Flight Inc · Fort Lauderdale, FLFirst renewal noticeBuilt 1980 · S/N 402C-0231 N9980GSchwend Brian · Forsyth, MTBuilt 1971 · S/N 18800780 N9982YChin-Loy Christopher Wayne Trustee · Tamarac, FLBuilt 1982 · S/N 21064659 N9983MTate Clint · Boise, IDBuilt 1978 · S/N U20604632 N9983RHellmann Andrew P · Newark Valley, NYBuilt 1986 · S/N U20607011 N9986MLogan Timothy R · Valley City, NDS/N U20604635 N9987NUnited States Department Of Interior · Boise, IDBuilt 1982 · S/N 18504379 N998CDLindsay Allan · Papillion, NEBuilt 2003 · S/N 0482 N998DAProfessional Vision Group Inc · Cornelius, NCBuilt 2008 · S/N E-3846 N998JA2 Doods LLC · Lakewood Ranch, FLBuilt 1979 · S/N 310R0938 N998JGDragonfly Aviation LLC · Davie, FLBuilt 1999 · S/N EA-641 N998LSTalton Rentals LLC · Tupelo, MSBuilt 1998 · S/N E-3204 N998PLStormy Aviation LLC · Fargo, NDBuilt 1996 · S/N E-3036 N998PMWirth Aviation LLC · Scottsdale, AZBuilt 1999 · S/N E-3251 N998WTMkeair LLC · Waukesha, WIBuilt 2002 · S/N 0210 N9991Sale Reported · Kalispell, MTSale reported, canceledBuilt 2001 · S/N 0079 N99910Roof Management Ltd · Marysville, OHBuilt 1975 · S/N D-9767 N99914Roof Management Ltd · Marysville, OHBuilt 1970 · S/N D-9178 N9991YArwlb Aviation LLC · Spokane, WABuilt 1982 · S/N 210-64661 N9992ZAdvanced Placement Aviation LLC · Eagle River, AKBuilt 1984 · S/N U20606800 N9993Pro Team Aviation LLC · Jonesboro, ARBuilt 1970 · S/N D-9175 N9996JDiamond X LLC · Elko, NVBuilt 1982 · S/N T18803925T N9996MYr-Aircraft Leasing LLC · Bethel, AKBuilt 1984 · S/N 20700779 N9996VMoore Mace L · Friendswood, TXBuilt 1971 · S/N 30339 N9999XBogart Sean A · Anchorage, AKBuilt 1961 · S/N 185-0199 N999AJNedley Aviation LLC · Wilmington, DEFirst renewal noticeBuilt 1984 · S/N EA-417 N999AKBarber Aviation LLC · Wilmington, DEBuilt 1979 · S/N TH-1069 N999ANOsi Air LLC · Wilmington, DEBuilt 2005 · S/N 1668 N999AVSouza Engineering Contracting Inc · San Luis Obispo, CABuilt 1979 · S/N P21000257 N999BCCcc Aviation LLC · Havre, MTBuilt 1965 · S/N D-7836 N999BFRigel Aviation Inc · Jefferson Hills, PABuilt 1979 · S/N EA-24 N999BSSale Reported · Moss Beach, CASale reported, pending cancellationBuilt 1968 · S/N 320F-0041 N999CECb Wings LLC · Eugene, ORBuilt 1980 · S/N EA-86 N999CWDunn Mark P · Visalia, CABuilt 1973 · S/N TH-291

Back to AD 86-13-04 R3