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.

N5784KN5784k LLC · Kalispell, MTBuilt 1964 · S/N D-7567 N5786KRocket Investments LLC · Independence, MOBuilt 1964 · S/N D-7570 N578CDCarothers Donald Luis · Bakersfield, CABuilt 2005 · S/N 1643 N578PSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 0966 N578UHawley Elizabeth · Wichita Falls, TXBuilt 1978 · S/N D-10206 N5793MCoxbill Farms Inc · Torrington, WYBuilt 1969 · S/N 310P0093 N5796JRegistered aircraftBuilt 1971 · S/N 21059496 N57977Denney Dennis · New Port Richey, FLBuilt 1976 · S/N 21061475 N5797KBank Of Utah Trustee · Salt Lake City, UTBuilt 1964 · S/N D-7586 N5799JBritt Demolition And Recycling Inc · Hanceville, ALBuilt 1971 · S/N 21059499 N579DMDiggins David A · Corpus Christi, TXS/N E-1769 N579JDForst Kenneth D DBA · Grand Rapids, MNBuilt 1980 · S/N 18503964 N579SVTorrey Daniel B · Santa Paula, CABuilt 1979 · S/N 79-30952 N57AMclallen Holdings LLC · Saint Charles, ILBuilt 1980 · S/N P21000564 N57CABlue Sky Management LLC · Stevens Point, WIBuilt 1975 · S/N 18502698 N57CFTurbett Theodore T · Houston, TXBuilt 1972 · S/N D-9358 N57CXDmdt Ventures LLC · Victor, NYBuilt 1986 · S/N 46-8608013 N57DMPrecision Aviation Inc · Tulsa, OKBuilt 1999 · S/N 30-0014 N57DYClair William E Jr · Casper, WYBuilt 1978 · S/N 78-30867 N57FECavu Air LLC · Lees Summit, MOBuilt 2005 · S/N 1521 N57FMCohen Aaron H · Chattanooga, TNBuilt 1999 · S/N 30-0034 N57GGGerhart Gary Elmer · Houston, TXBuilt 1978 · S/N E-1385 N57GWHardin Thomas H III · Sonoita, AZBuilt 1989 · S/N CE-1398 N57GXJfp Aviation Inc · North Fort Myers, FLBuilt 2005 · S/N 29-0357 N57KYPatterson John M · Frankfort, KYBuilt 2023 · S/N E-4154 N57PGulf Sierra Aviation LLC · Owasso, OKBuilt 1979 · S/N TH-1059 N57PBHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0300 N57PLChandler Aviation Inc · Georgetown, SCBuilt 2012 · S/N E-3975 N57RBDavis Timothy M · Yelm, WABuilt 1979 · S/N E-1572 N57SBRadkey Edward B · Humble, TXBuilt 1979 · S/N E-1467 N57TCNiemi Aviation LLC · Glyndon, MNBuilt 1968 · S/N D-8693 N57TUKagley Larry D · Greenwood, SCBuilt 2002 · S/N 0377 N57TWBc & Tw Flying Service LLC · Hot Springs, ARBuilt 1982 · S/N EA-288 N57UMMichaud David · Naples, FLBuilt 1984 · S/N CE-1039 N5800MRidgewood Associates Inc · Nevada City, CAS/N 310P0100 N5804KHarrell Jeff E · Cedar Park, TXBuilt 1965 · S/N D-7831 N5805JLanni Ronald A · Fairbanks, AKBuilt 1970 · S/N 18501774 N5805KDoran James V · Saint John, KSBuilt 1965 · S/N D-7833 N5806FJones Flying Association · Wilmington, DEBuilt 1966 · S/N 21058806 N5806SAg Solutions Of West Texas LLC · Roby, TXBuilt 1964 · S/N D-7720 N5807JForsgren Keith C · Wasilla, AKBuilt 1970 · S/N 18501776 N5809FDonnelly Robert J · Edwardsburg, MIBuilt 1966 · S/N 21058809 N5809SRegistered aircraftBuilt 1964 · S/N D-7717 N580CXWicked Wings Aviation LLC · Dover, DEBuilt 2010 · S/N TH-2277 N580EN580e LLC · Hickory, NCBuilt 1995 · S/N TH-1758 N580SMMacair Leasing LLC · Cocoa, FLBuilt 2015 · S/N TH-2444 N580TF1294 Transportation Corp · Speonk, NYBuilt 2004 · S/N 18281317 N580WFry Michael David · Madeira Beach, FLBuilt 1976 · S/N TH-774 N5811SCampbell Andrew S · Lake Havasu City, AZBuilt 1964 · S/N D-7719 N5812JBedford Dennis L · Auke Bay, AKBuilt 1970 · S/N 18501781

Back to AD 86-13-04 R3