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.

N9272RFarrow Sammie N Jr · Cordele, GABuilt 1975 · S/N 18802200T N92734Clark Iain · San Jose, CABuilt 1996 · S/N 166 N9273QFrost Scott · West Palm Beach, FLBuilt 1971 · S/N E-280 N9275YInternational Air Services Inc Trustee · Carson City, NVS/N 46-8608026 N9276QSunrise Aeronautics LLC · Punta Gorda, FLBuilt 1971 · S/N CE-342 N927AWLambert Contracting LLC · Hollywood, ALBuilt 2001 · S/N E3426 N927DCCiruli David E · Lafayette, CABuilt 1976 · S/N D-9855 N927JVne Enterprises LLC · Oneida, TNBuilt 2004 · S/N L2K-239 N927JBAirgroup Express LLC · Santa Rosa, CABuilt 1980 · S/N D-10345 N927MBGlobal Aircraft Management And Operations LLC · Thomasville, GABuilt 2001 · S/N 40031 N927MWStrauss Michael · Ormond Beach, FLBuilt 1973 · S/N D-9546 N9281YSharp Darren J · Musselshell, MTBuilt 1986 · S/N 46-8608027 N9282QMsxpert LLC · Sheridan, WYBuilt 1971 · S/N TE-842 N9283RAllied Sprayers Inc · Hawley, TXBuilt 1975 · S/N 18802211 N9286QDunn Louis · Hampshire, ILBuilt 1971 · S/N E-291 N9286RWiebe Aerial Applications LLC · Peabody, KSBuilt 1975 · S/N 18802212 N9287QElarel Corporation · Lewes, DEBuilt 1971 · S/N D-9287 N9288QKarle John F · Long Beach, CABuilt 1971 · S/N E-288 N9289QCoutu Bobby L · Plano, TXBuilt 1971 · S/N D-9289 N928CRCasas De Colores Inc · Santa Fe, NMBuilt 1977 · S/N 340A0434 N928DMEllis Leven Handy IV Trustee · Champions Gate, FLS/N 421B0835 N928HBRegistration Pending · New Brunswick, NJRegistration pendingS/N TH-172 N928KMSchmoker William C · Eden Prairie, MNBuilt 2001 · S/N EA-672 N928MMRegistration Pending · Mesa, AZRegistration pendingBuilt 1969 · S/N D-8942 N928RSEzskies Air Service LLC · Hayden, IDBuilt 1978 · S/N TJ-138 N92903Nalle W B · Austin, TXBuilt 1981 · S/N 310R2140 N9293QChalk 2 Inc · Apple Valley, CABuilt 1971 · S/N D-9293 N9294HWet Dreams LLC · Erwinna, PABuilt 1977 · S/N 18503428 N9295YSln Aviation LLC · Salina, KSBuilt 1986 · S/N 46-8608032 N9296QReichert Aviation Enterprises LLC · El Cajon, CABuilt 1971 · S/N D-9294 N929CPSpark Aviation LLC · Shreveport, LAS/N 0856 N929DCPremier Flight LLC · El Cajon, CABuilt 1979 · S/N 340A0934 N929DEDodson International Parts Inc · Rantoul, KSBuilt 2002 · S/N 0293 N929HBSaratoga Transporation LLC · Encino, CAS/N 414-0509 N929JDMake Aviation Great Again LLC · Kalispell, MTBuilt 1987 · S/N E-2387 N929RSchneider Franz · Bacliff, TXBuilt 2001 · S/N 0133 N929RBBurgair LLC · Plano, TXBuilt 2009 · S/N E-3902 N929RHJohnson Merlin K Trustee · Mentone, CABuilt 1964 · S/N 206-0061 N92BMNugent James S · Diamondville, WYS/N P21000557 N92BZWhelan Holdings LLC · Howardstown, KYBuilt 2004 · S/N 0908 N92CDZeneski Andrew J Sr · Wake Forest, NCBuilt 2002 · S/N 0299 N92CKKingsborough James D · Carlisle, PABuilt 1978 · S/N P21000160 N92CVRandall Grier Ministries · Owasso, OKBuilt 1984 · S/N 421C1065 N92DKruckeberg John R · Sanford, NCS/N DUNHAM 0002 N92DCAdams Bob L · Eagle River, AKBuilt 1975 · S/N 18502828 N92DLDavis Air LLC · Phoenix, AZBuilt 1976 · S/N 340A0204 N92DSBooty Bill · Idaho Falls, IDBuilt 1975 · S/N 21060847 N92FFAircraft 2 Go ! Inc · Wilmington, DES/N TH-1167 N92HJWoolley Air LLC · Kilgore, TXBuilt 1991 · S/N TH-1621 N92HWWinners Church Inc · Edmond, OKBuilt 1999 · S/N 30-0012

Back to AD 86-13-04 R3