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.

N9094QAhrens Nathan · Groveland, CABuilt 1970 · S/N TH-107 N9094RPetecraft Aviation Services Inc · Plains, GABuilt 1975 · S/N 18802110T N9094SZompa Edward A Md Phd · Galveston, TXBuilt 1978 · S/N D-10152 N9095QApt Jerome III · Pittsburgh, PABuilt 1970 · S/N D-9221 N9095SPowers Land Management Service Inc · Lyons, INBuilt 1986 · S/N 46-8608061 N9098QBuckeye Baron LLC · Sunbury, OHBuilt 1970 · S/N TH-109 N9098UGlobal T & E Inc · Mcallen, TXBuilt 1986 · S/N 4608025 N9099DRegistered aircraftBuilt 1986 · S/N 46-8608066 N9099SRegistration Pending · Davis, CARegistration pendingBuilt 1976 · S/N E-814 N909AAKings Wings Inc · Jupiter, FLBuilt 1968 · S/N 401-0227 N909ATGo Consultants LLC · Wilmington, DES/N E-2647 N909DCTwin Piston Aviation LLC · Salisbury, NCBuilt 1980 · S/N 340A0998 N909GBHead West Lake Operations LLC · Dubois, WYBuilt 1978 · S/N 18503519 N909MDEmber Brett D · Cottondale, ALBuilt 1970 · S/N D-9210 N909RFPastjo Aviation LLC · Charleston, WVBuilt 1982 · S/N 414A0840 N909SDAcqua Aviation Inc · Wayzata, MNBuilt 1960 · S/N 310M0027 N909VBBedalou Aviation LLC · Joplin, MOBuilt 1997 · S/N E-3133 N90CDCirrus Pilots Flying Group · Hillsborough, NJBuilt 2004 · S/N 0939 N90DMDel Martin Lp · Spring, TXBuilt 1972 · S/N 340-0048 N90EBJet Set Aircraft Inc · Van Nuys, CABuilt 1976 · S/N TH-793 N90HFNovak Todd · Lumberton, NJBuilt 1990 · S/N CE-1495 N90KRKoch Leasing LLC · Campbellsville, KYBuilt 1965 · S/N D-7892 N90MBBleeker Buchanan B · Flagstaff, AZBuilt 1973 · S/N 21060153 N90MWBueter Brandon P · Northville, MIBuilt 1980 · S/N 18504073 N90RWWallace Richard · Santa Teresa, NMBuilt 1979 · S/N 21063283 N90SNMortvedt Arthur D Trustee · Manley Hot Springs, AKBuilt 1980 · S/N 18504109 N90TFMonterey County Sheriffs Office · Salinas, CABuilt 1980 · S/N U20605859 N90TLColorado Aviators LLC · Gypsum, COBuilt 1979 · S/N P21000206 N90TMJ&W Aviation LLC · Taylor, NEBuilt 1976 · S/N D-9839 N90WSShettle William M · Pocomoke City, MDBuilt 1976 · S/N 21061695 N91002Yr-Aircraft Leasing LLC · Bethel, AKBuilt 1969 · S/N 20700003 N9100UFly Mcble LLC · Huntsville, ALBuilt 1986 · S/N 4608011 N91016Gosselin Edward M Trustee · Bridgewater, NJBuilt 1969 · S/N 20700011 N9101FSkaw Jack E · New Auburn, WIBuilt 1975 · S/N 18502811 N9101QSims Air LLC · Cincinnati, OHBuilt 1986 · S/N 4608015 N91025Arctic Aviation Leasing LLC · Anchorage, AKBuilt 1969 · S/N 20700016 N9102QLarosa Christopher · Tampa, FLBuilt 1970 · S/N D-9227 N91045Dakota Aircraft Specialists LLC · Hot Springs, SDBuilt 1975 · S/N 414-0623 N9105SDominguez Cesar Trustee · Yuma, AZBuilt 1976 · S/N CE-630 N91060Second Wind Aviation Corp · Friday Harbor, WAS/N 20700047 N9106MWeekley Marlin · Metamora, ILBuilt 1977 · S/N 21062062 N9107QRitter Disposables Inc · Marion, ARBuilt 1971 · S/N E-241 N91084Cropair Flying Service Inc · Cody, WYBuilt 1975 · S/N 18802020T N9109MAr Malibu LLC · Gassville, ARBuilt 1985 · S/N 46-8608006 N9109SThomas Timber Inc · Harrells, NCBuilt 1976 · S/N E-816 N910BFAlpine Aviation Of Fayetteville Inc · Fayetteville, ARBuilt 2013 · S/N E-4002 N910EJNoble John E · New Kent, VABuilt 1971 · S/N 30405 N910JVDunmire Properties LLC · Goldsboro, NCBuilt 2018 · S/N 32-0004 N910MFly By Night Aviation LLC · San Francisco, CABuilt 1979 · S/N 310R1653 N910RHDelaurentis Robert · Oak Harbor, WABuilt 1984 · S/N 46-8408066

Back to AD 86-13-04 R3