Registered aircraft · 40,397

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:79-10-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2') 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:79-10-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  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:79-10-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
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.

N13BWMundy Christopher James · Vienna, VABuilt 1993 · S/N 20436 N13CBT&W Aviation LLC · Pinehurst, TXBuilt 1981 · S/N 17274805 N13CKDicksion Archie M · Phoenix, AZBuilt 1962 · S/N 28-362 N13DBBauer Dereck R · Springfield, ORFirst renewal noticeS/N 12-2919 N13DDRowland Brent · Whitewright, TXBuilt 1983 · S/N 0131 N13EKKinkade Emmett S · 2088 Cressier NeBuilt 1996 · S/N 002 N13GHEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1984 · S/N 0388 N13GYMarvin Dean · Senoia, GABuilt 2001 · S/N 81355 N13HADuvernet Jon William · Steinhatchee, FLBuilt 1988 · S/N 370 N13HKSkycombers Flying Club Inc · Pacoima, CABuilt 1972 · S/N 17701810 N13HRSouth Florida Helicopters Inc · Indiantown, FLS/N 0492 N13HYKahler Enterprises LLC · Reedsburg, WIBuilt 1999 · S/N 2050 N13JPFour Kicks Aviation LLC · Atlantic, IABuilt 2015 · S/N 73284 N13JTHoltzclaw Timothy M · O Brien, FLBuilt 1972 · S/N 17261008 N13KENickson Dennis A · Cameron Park, CABuilt 1982 · S/N 753 N13KFRockwood Blake T · Fort Worth, TXBuilt 1965 · S/N 28-2396 N13KKSanders Flight Training Center Inc · Jasper, ALBuilt 1977 · S/N 17268760 N13KRKaplan Ronald · Palm Beach Gardens, FLBuilt 1967 · S/N 28-4363 N13LFLuciano Michael · Peachtree City, GABuilt 2007 · S/N 70830 N13MPPowell & Powell LLC · Northport, ALS/N 28-7515384 N13MRMead Sidney O · Wichita, KSBuilt 1991 · S/N 1356 N13SKFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1978 · S/N 17271183 N13SR10 Skies LLC · Corpus Christi, TXBuilt 1989 · S/N R-1 N13TMSuntech LLC · St George, UTBuilt 1963 · S/N 115 N13TPLehman Aviation LLC · Remington, INBuilt 1976 · S/N 17267454 N13TXBarger Janet A · Bedford, INBuilt 1992 · S/N 1625 N13VCWhite Paul J · Apex, NCBuilt 2004 · S/N 0002 N13VSHunton Hugh R II · Midlothian, TXS/N 723 N13YPBlock Scott M · Chandler, AZBuilt 1968 · S/N 17257055 N13YVRegistered aircraftBuilt 1984 · S/N 2137 N1401EUnited States Air Force Aero Club · Usaf Academy, COBuilt 1978 · S/N 17270986 N14033Nomadic Flight Training LLC · New Castle, DES/N 28-25388 N14038Eagle Aviation And Logistics LLC · Cheyenne, WYS/N 700017 N1403VSmith Dennis A Trustee · Salem, ORBuilt 1974 · S/N 17263550 N14043Beranek James D · Cottage Grove, ORBuilt 1972 · S/N 18-8986 N14044Myron Kurt J · Elbow Lake, MNBuilt 1972 · S/N 18-8987 N1404CAeroscalper LLC · Goshen, INBuilt 1977 · S/N 17702721 N14050M & K Flying Service Inc · Hot Springs Vill, ARBuilt 1975 · S/N 857-75 N1405UGuardian Aerial Patrol LLC · Edmond, OKBuilt 1976 · S/N 17267075 N1405XRij Edward · Clovis, CABuilt 1975 · S/N 28-7515292 N14060Skinner Daniel R · Mount Airy, GABuilt 1964 · S/N 28-20333 N14064University Of Central Missouri · Warrensburg, MOBuilt 1972 · S/N 18-8989 N1406CMcaninch Danny Ray · Pleasant Hill, CABuilt 1977 · S/N 17702722 N1407UN R I Flying Club · Walnut Creek, CABuilt 1976 · S/N 17267077 N1407XRavotti Air LLC · Leechburg, PABuilt 1975 · S/N 28-7505224 N1408CHaworth Michael R · Riverside, CABuilt 1977 · S/N 17702723 N1408TCarter Jeff · Paragould, ARS/N 28-7225505 N1409TAnker Mark W · Cambridge, OHBuilt 1972 · S/N 28-7225506 N140ACApplebaugh Jeffrey · Mechanicsville, MDBuilt 1968 · S/N 28-25001 N140AMSuchko Paul S · Venetia, PAS/N 28-26418

Back to AD 79-10-03 R2