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.

N34KFRsb Properties LLC · Lewes, DES/N P21000700 N34KMBravo Adventures LLC · Scottsdale, AZBuilt 1981 · S/N EA-207 N34LWAnderson Glenn L · Sandia Park, NMBuilt 1956 · S/N BG-160 N34MMSchubee Air Inc · Watkins, COBuilt 1967 · S/N 401-0125 N34MXEwald Robert H · Red Lodge, MTBuilt 1984 · S/N PG-114 N34NCSpencer Coastal Air LLC · Ellsworth, MEBuilt 1979 · S/N 18503886 N34NYKeys Robert · Menifee, CABuilt 1973 · S/N 340-0196 N34RInfinity Welding And Fabrication LLC · Celina, TXBuilt 2002 · S/N L2K-174 N34SCTbhb Logistics LLC · Amarillo, TXBuilt 1978 · S/N TH-943 N34SYGeneral Aviation Modifications Inc · Ada, OKBuilt 1956 · S/N BG-246 N34TGTri W Inc · Shepherd, MTBuilt 2002 · S/N 0386 N34TLAmeagle Aviation LLC · Coventry, CTBuilt 1977 · S/N 340A0423 N34VFRomag Air Services Inc · Mc Lean, VAFirst renewal noticeBuilt 1979 · S/N P21000307 N34VMRoberts Glenn T · Port Orange, FLBuilt 1954 · S/N G-98 N34WEWildes Thomas O · Chippewa Falls, WIBuilt 1979 · S/N 310R1597 N34WWChute Aviation LLC · Prescott, AZBuilt 1973 · S/N 340-0258 N34YKHood Frank A · Burlington, NCBuilt 1956 · S/N 144000 N350ABierlein Aviation LLC · Midland, MIBuilt 1977 · S/N 340A0325 N350BLAustin Neal · Fort Myers, FLBuilt 2003 · S/N 42006 N350CTMaas Karl G · La Crosse, WIBuilt 1966 · S/N CE-14 N350DGQualitair LLC Trustee · MichelstadtBuilt 2005 · S/N 42074 N350ELCowick Glen M · Hollister, CABuilt 2001 · S/N ES-016-FB N350GMCannonball Trucking Inc · Houston, TXBuilt 1978 · S/N 414A-0120 N350GZValiair Lc Trustee · Casper, WYBuilt 1979 · S/N P21000382 N350HAims Community College · Greeley, COS/N D-8188 N350JCWear On Earth Aviation LLC · Potsdam, NYBuilt 1975 · S/N 310R0606 N350LCDaly Arthur P · El Paso, TXBuilt 1978 · S/N P21000049 N350NEMaresco International Corp · Alpha, NJBuilt 1980 · S/N D-10351 N350NWBas Part Sales LLC · Greeley, COBuilt 1977 · S/N CE-753 N350PGGuerra Michael E · Kerrville, TXBuilt 2003 · S/N 42005 N350RPShy Dennis · Cape Coral, FLBuilt 2004 · S/N 42046 N350SFTakamatsu Hiroaki · Redmond, WAS/N 42062 N350TBStephenson Richard J Trustee · Wheeling, ILBuilt 1973 · S/N E-413 N350TMJefferies Stanley J · Coos Bay, ORBuilt 1969 · S/N 21059125 N350YRSilverman Kenneth · Pelham, NHBuilt 1982 · S/N D-10383 N3511VCypress Creek Shooting Lodge LLC · Greenbrier, ARBuilt 1980 · S/N D-10353 N351ABTropical Transport Services Ltd · San Juan, PRBuilt 1980 · S/N 402C0351 N351ATRegistered aircraftBuilt 1967 · S/N D-8507 N351HCBig Elk Aviation LLC · Elk City, OKS/N 414A0801 N351JPParker Robert · Oklahoma City, OKBuilt 1976 · S/N TJ-51 N351RSSmith Herschel W III Md · Roswell, GABuilt 1966 · S/N D-8299 N351VBWudtke Dale A Trustee · Palos Park, ILBuilt 1970 · S/N D-9207 N3526ARoeder Miles · Houston, TXBuilt 1969 · S/N D-9075 N352RCN352rc Inc Trustee · Wilmington, DEBuilt 2002 · S/N 0186 N352RHHackler Russell W Jr · Livermore, CABuilt 1964 · S/N D-7562 N352TImpact Aviation LLC · Ballwin, MOBuilt 1973 · S/N 340-0227 N352TBJdc Aviation LLC · Gainesville, FLS/N E-4132 N352TSBoss Contract Services LLC · Terry, MTBuilt 1972 · S/N 414-0352 N353Giddings Thomas C · Fort Myers, FLBuilt 1999 · S/N AT-7 N3532AGuedon Aviation LLC · Natchez, MSBuilt 1969 · S/N CE-289

Back to AD 86-13-04 R3