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.

N777BMJet Air Of South Florida Inc · Deerfield Beach, FLBuilt 1978 · S/N 21063156 N777BVPowell Robert W · Horseshoe Bay, TXBuilt 1971 · S/N TE-829 N777CEMiller Dana · Tracy, CABuilt 1977 · S/N D-10019 N777CFCp Aviation LLC · Pasco, WABuilt 1977 · S/N 21062059 N777CSKuss Mark A · Granbury, TXBuilt 1969 · S/N CE-274 N777CZFunchess Thomas A · Hazlehurst, MSBuilt 1970 · S/N TE-809 N777DPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1981 · S/N 340A-1257 N777DKLeeth Bryan Conway · Carrollton, GABuilt 1967 · S/N TE-443 N777DLShamrock Kelly Energy Inc · Blanco, TXBuilt 1979 · S/N P21000373 N777EConner Ernest A · Dallas, TXBuilt 1981 · S/N TJ-347 N777EVSelldorff John · Chatham, MABuilt 1990 · S/N E-2520 N777FHShort Final LLC · Mooresville, NCBuilt 1964 · S/N D-7530 N777FWLewis Kent · Lake Oswego, ORBuilt 1974 · S/N 21060167 N777FYQualitair LLC Trustee · ChelstadtBuilt 1979 · S/N P21000276 N777GTShillings Phillip J · Goldthwaite, TXS/N 21058339 N777GVPerry Robert A · Tucson, AZBuilt 2002 · S/N 0235 N777HBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 73-30609 N777HGProcyon Group Inc · Wilmington, DEBuilt 1975 · S/N E-777 N777HMMusser Harold R · Cody, WYBuilt 1980 · S/N 18504048 N777HSJohnson Erik L · Long Beach, CABuilt 1975 · S/N 21060835 N777JMFulton David S · Austin, TXBuilt 1966 · S/N D-8085 N777KWBenner Dick L · Clancy, MTBuilt 1968 · S/N D-8892 N777MYGraham Elmer R Jr · Graford, TXBuilt 2000 · S/N E-3328 N777NHS And S Airlink · Troy, MIBuilt 1978 · S/N 340A-0415 N777NKTaylor Jonathan K II · Granbury, TXBuilt 1996 · S/N E-2996 N777NNInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N CE861 N777NTN777nt LLC · Fort Mill, SCBuilt 1975 · S/N 21060972 N777PDIsr Aviation LLC · Wilmington, DEBuilt 1981 · S/N D-10380 N777PSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N 0097 N777QAMabry Kelly · Russellville, ARBuilt 1970 · S/N TH-143 N777RKing Winn K · Gladewater, TXBuilt 1972 · S/N 21059551 N777RABirdsong Michael L · St Simons Island, GABuilt 1981 · S/N TH-1273 N777RPParis Air Conditioning Co · Paris, TXBuilt 1974 · S/N 414-0636 N777RQSchelde Brian L · Marble Falls, TXBuilt 1973 · S/N TH-298 N777RRChalk 2 Inc · Apple Valley, CABuilt 1977 · S/N 21061729 N777RYMacair Aviation LLC · Xenia, OHBuilt 2003 · S/N 0777 N777SGClaw LLC · Lake Saint Louis, MOS/N TH805 N777SZMullen John J Jr Trustee · Henderson, NVBuilt 1970 · S/N 21059265 N777TKProfessional Paving Services LLC · Macon, GABuilt 1979 · S/N TH-1018 N777TLStemmer Steven N · Huntersville, NCBuilt 1966 · S/N D-8302 N777TSEmery Edward F DBA · Bloomsburg, PAFirst renewal noticeS/N 421B0352 N777UPerez Michael Joel D · San Diego, CABuilt 1970 · S/N D-9096 N777USCurley James L · Oneida, TNBuilt 1966 · S/N TE-182 N777VMiso Enteprises LLC · Wilmington, DES/N 310R0267 N777VBArizona Thunderbolts LLC · Scottsdale, AZBuilt 1992 · S/N EA-539 N777VFZammit Flight Resources LLC · Sheridan, WYBuilt 1977 · S/N 414-0946 N777VRRoquemore William A Jr · Lakeland, GAS/N 385 N777WLAerospace Trust Mangement LLC Trustee · Wilmington, DEBuilt 1970 · S/N 21059376 N777WVIndependent Mortgage · Westlake, LABuilt 1996 · S/N TH-1784 N777WXMullins William Scott · Senoia, GABuilt 2003 · S/N 0452

Back to AD 86-13-04 R3