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.

N857CGRbf Partners LLC · Chattanooga, TNS/N E-1128 N8580QBald Eagle Aviation LLC · Oakley, UTBuilt 1976 · S/N U20603436 N8583RFresa Oro Inc · Carlsbad, CABuilt 1974 · S/N CE-538 N8584RRjm Aero Inc · Fallbrook, CABuilt 1974 · S/N CE-539 N8586RRj Sprik Aviation Services LLC · La Porte, INFirst renewal noticeBuilt 1974 · S/N CE-540 N858ALFinnegan Brian · Novato, CABuilt 1990 · S/N E2544 N858BBEchelon Group Inc · Boise, IDBuilt 1979 · S/N 21063277 N858DFulmer Robert Alan · Irvine, CABuilt 1966 · S/N D-8200 N858JAAms Aviation LLC · South Bend, INBuilt 1976 · S/N U20603437 N858LALane Aviation Inc · Rosenberg, TXBuilt 2008 · S/N TH2230 N858LPFulps Aviation LLC · Winston Salem, NCBuilt 1978 · S/N TH-902 N858MLLang Inc · Wilmington, DEBuilt 1980 · S/N TJ-257 N858NCIal Corp · Lewes, DEBuilt 1977 · S/N TH-813 N858PRMelbourne Air Partners LLC · Indialantic, FLBuilt 1981 · S/N TH-1221 N858TCH2 Transportation LLC · Macon, GABuilt 1979 · S/N TK-98 N8592QSkyview Aviation Holdings LLC · The Hills, TXBuilt 1976 · S/N U20603448 N8594QParkerson Stan L · Fairbanks, AKBuilt 1976 · S/N U20603450 N8598MMerrill Gregory T · Fresno, CABuilt 1963 · S/N D-7228 N8598QTolley Samuel M · Rangely, COBuilt 1976 · S/N U20603453 N8599QForbes Paul J · Anchorage, AKBuilt 1976 · S/N U20603454 N859ALAms Aviation LLC · South Bend, INBuilt 1979 · S/N U206-04888 N859CBoe Ndt LLC · Haysville, KSBuilt 2001 · S/N E-3395 N859DLBryant Charles Martel · Dallas, TXBuilt 1976 · S/N 18503134 N859DMDavis Mark E · Pearland, TXS/N 421C0859 N85AJBha Leasing Inc · South Portland, MEBuilt 1977 · S/N 18503424 N85AMLitchfield Lantz Dr · Las Vegas, NVBuilt 1973 · S/N 414-0435 N85AXMidwest Aviation Inc · Mayfield, KYBuilt 2008 · S/N E-3876 N85BAMclean Randy Justin · Taylorsville, NCBuilt 1968 · S/N D-8820 N85BBAvanti Aviation LLC · Bellevue, NEBuilt 1973 · S/N E-508 N85DAGp Aviation Services LLC · Wilmington, DEBuilt 2004 · S/N 1085 N85DTPolashenski Christopher · Fairbanks, AKBuilt 1978 · S/N 18503474 N85FS7353r Co Partnership · Pottstown, PABuilt 1974 · S/N TH-486 N85JS85 Juliet Sierra LLC · Chico, CABuilt 1970 · S/N CE-303 N85JXKahonees Air Service LLC · Bozeman, MTBuilt 1973 · S/N 18502298 N85KAMancini Christopher S · Houston, TXBuilt 1977 · S/N 18503404 N85LCCoyote Air LLC · Fairbanks, AKBuilt 1975 · S/N 18502643 N85LZJacques Jerry J · Iliamna, AKBuilt 1975 · S/N 18502777 N85MEGlobal Petroleum Services LLC · Greenville, SCBuilt 1978 · S/N TJ-168 N85MVAerownership North American Services Inc Trustee · Wilmington, DEBuilt 2018 · S/N TH-2506 N85PEMidwest Airmotive Inc · Mount Sterling, KYBuilt 1975 · S/N U20602774 N85PGN85pg LLC · Atlanta, GABuilt 1985 · S/N 46-8508066 N85RTJetprop Aviator LLC · Lewes, DEBuilt 1985 · S/N 8508033 N85SLRegistered aircraftBuilt 2007 · S/N E-3813 N85SNSn Inc · Seattle, WAS/N 18501844 N85WFTim Decker Aviation LLC · Franklin, TNBuilt 2005 · S/N 1384 N85WMDiaz Oscar Jr · Raleigh, NCBuilt 1981 · S/N CE-943 N85XYWilliams Jerome L · Forkland, ALBuilt 1977 · S/N 18503370 N8600QSpano Darren · Deville, LABuilt 1964 · S/N D-7630 N8600ZChamberlin Aviation · East Wenatchee, WABuilt 1967 · S/N P206-0400 N8601ZMagnolia Springs Properties Inc · Kirbyville, TXS/N P206-0401

Back to AD 86-13-04 R3