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.

N4271SVk Aviation LLC · Jennings, LABuilt 1976 · S/N E-944 N4272CKamps Air LLC · Grand Rapids, MIBuilt 1982 · S/N 414A0849 N4272QKeech Mark A · Fairbanks, AKBuilt 1976 · S/N U20603042 N4272SSchechter Stuart · Great Neck, NYBuilt 1976 · S/N D-9959 N4273RYuknis Leonard F · Wasilla, AKBuilt 1976 · S/N 18502924 N42776Hap'S Air Inc · Ames, IABuilt 1973 · S/N 421B0394 N4279SSteinbacher Deane E · Waterford, WIBuilt 1976 · S/N E-948 N427ATMockingbird LLC · Bloomington, INBuilt 2004 · S/N 0954 N427BDNostra Aeris LLC · Gassville, ARBuilt 1991 · S/N EA528 N427CAChippewa Aerospace Inc · Gainesville, FLBuilt 1976 · S/N 310R0653 N427CWRural Orthopedic Care LLC · Ardmore, OKBuilt 2001 · S/N E-3400 N427DWFlyin Phar LLC · Salt Lake City, UTBuilt 1979 · S/N TK-113 N427HHSinopoli Albert L · Friendswood, TXFirst renewal noticeBuilt 2007 · S/N E-3770 N427LLForrest Jeffrey H · Bloomfield Hills, MIBuilt 1977 · S/N CE-679 N427PWLangford Stephen C · York, SCBuilt 1976 · S/N D-9850 N42800Asbury William J · Fresno, CABuilt 1976 · S/N D-9934 N4280QHines Thomas J · Amsterdam, NYBuilt 1973 · S/N 18502230 N4280SYoung Daniel R · Germantown, TNBuilt 1976 · S/N D-9969 N4282PAero Tramp Holdings LLC · Dallas, TXBuilt 1999 · S/N E-3282 N4282SGoerzen John P · Goessel, KSBuilt 1976 · S/N E-946 N4287AWilliam Dolson And Associates LLC · Santa Fe, NMBuilt 1980 · S/N 340A1010 N428AJetpropmontana LLC · Cameron, MTBuilt 1986 · S/N 4608031 N428AKOlsen Martin G · Anchorage, AKBuilt 1976 · S/N 18502917 N428DLGiair LLC · Morristown, TNBuilt 1976 · S/N 310R0657 N428JAJones Terry W · Houston, TXBuilt 2017 · S/N E-4104 N428KRLilly James D · Columbia, MDBuilt 1972 · S/N D-9306 N428TLight Korbin T · Midland, TXBuilt 2001 · S/N 0049 N428TLJoe Rushing Plumbing Co Inc · Lubbock, TXBuilt 1967 · S/N D-8632 N428TMBlue Jay Omni Bearing LLC · Fargo, NDS/N 0167 N4291QRegistered aircraftBuilt 1976 · S/N U20603043 N4298YAir LLC · Fresno, CABuilt 2001 · S/N TH-1998 N429CDQualitair LLC Trustee · MichelstadtBuilt 2004 · S/N 1064 N429DLLandset David J · West Palm Beach, FLBuilt 1975 · S/N 21060649 N429GMResendiz Marcelino · Alamo, TXBuilt 1982 · S/N 421C1251 N429LDBonanza44 LLC · Fort Myers, FLBuilt 2016 · S/N E-4084 N429MAirmart Inc · Lexington, KYBuilt 2014 · S/N TH-2422 N429PDupuy William C · Waco, TXBuilt 2000 · S/N E-3356 N429PSMjk Leasing LLC · San Antonio, TXBuilt 2006 · S/N 29-0429 N429RTrinity Point Enterpises LLC · Odessa, FLS/N E-4024 N429RCN429rc LLC · Gladwyne, PABuilt 1979 · S/N 414A0243 N42AAN42aa LLC · Nantucket, MABuilt 1979 · S/N 402C0238 N42AMGruhlkey William H · Wildorado, TXBuilt 1979 · S/N EA-29 N42AUBite Wing Aviation LLC · Wichita, KSBuilt 1982 · S/N CE-1010 N42BCRotary Components International Inc · Houston, TXBuilt 1975 · S/N 421B0922 N42BDKristoferson John S · Denton, TXBuilt 1988 · S/N 4608122 N42BJRegistration Pending · Oakland Park, FLRegistration pending, pending cancellationBuilt 1972 · S/N 421B0342 N42CWHollywood Of The South Flight School Ltd · Decatur, GABuilt 1979 · S/N P21000228 N42HMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 421C0683 N42JVCheshire Vincent Eugene Jr · Slidell, LABuilt 1980 · S/N CE-913 N42KWMarine Aviation LLC · Lyme, NHBuilt 2001 · S/N TH-1985

Back to AD 86-13-04 R3