Registered aircraft · 40,395

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.

N3578ZNance Gary L · Fairbanks, AKBuilt 1960 · S/N 18-7368 N35790Integrity Aviation Inc · Worthington, MNBuilt 1968 · S/N 17256963 N35795N35795 LLC · Fredericksburg, TXBuilt 1968 · S/N 17256965 N35798Big Sky Aviation LLC · Massillon, OHBuilt 1968 · S/N 17256967 N35799Huebner Otto · Bolingbrook, ILS/N 17256968 N3579ZMartin Michael J · Anchorage, AKS/N 18-7369 N357AHAtlantic Aviation International Inc · Lewes, DEBuilt 1987 · S/N 0711 N357CFCoast Flight Training And Management Inc · San Diego, CABuilt 1979 · S/N 447995091 N357DBBecker Mark D · Bismarck, NDBuilt 2006 · S/N 80635 N357DSBentley David K · Omaha, NEBuilt 1979 · S/N S-3 N357JWWoods Jim W · Lodi, CABuilt 1996 · S/N 01-1480 N357KKDkk LLC · Indian Rocks Beach, FLS/N 28-7715074 N357LHElite Aerial Photography Inc · Naples, FLBuilt 1992 · S/N 2254 N357MMcelroy Ronald D · Las Cruces, NMBuilt 1995 · S/N 1 N357MPEnsminger Edward C · Maryville, MOBuilt 1974 · S/N 28-7505103 N357MTJ & F Aviation Adventure LLC · North Fort Myers, FLS/N 28-21389 N357PPaphos Airways LLC · Farmingdale, NYBuilt 1977 · S/N 28-7816005 N357PMEumundi Trading Co · Wilmington, DEBuilt 1976 · S/N 187609154 N357RJJilek Ray A · Spearfish, SDBuilt 1956 · S/N 18-5071 N357SCDingess James D · Carson City, NVBuilt 1966 · S/N 18-8412 N357THutchison Warren L · Wasilla, AKS/N 18-2421 N35801Perkins Richard D · East Otto, NYBuilt 1968 · S/N 17256970 N35802Boeing Employees Flying Association Inc · Ridley Park, PAS/N 17256971 N3580KKline Justin L · Hudson, INBuilt 1967 · S/N 28-23638 N3580QSale Reported · Boise, IDSale reportedBuilt 1973 · S/N 17261680 N35810Mcintosh Aaron · Caldwell, TXBuilt 1968 · S/N 17256976 N35813Davis Daniel E · Doniphan, MOBuilt 1968 · S/N 17256978 N35815Cm3 LLC · North Las Vegas, NVBuilt 1968 · S/N 17256979 N3581KVick Michael S · Camden, ALBuilt 1967 · S/N 28-23639 N3581QQuantie Harold G · Locust Grove, OKBuilt 1973 · S/N 17261681 N3582KPine Point Aviation LLC · Sartell, MNBuilt 1967 · S/N 28-23641 N3583ZHanneman Logan L · Fairbanks, AKBuilt 1960 · S/N 18-7373 N3584KWilliamson Conner James · Hernando, FLBuilt 1967 · S/N 28-23643 N3584PWatson Frank D · Canton, PABuilt 1955 · S/N 18-4538 N3585Coon Donald N · Shedd, ORBuilt 2003 · S/N 25365 N3585QLerner Daniel A · East Durham, NYBuilt 1973 · S/N 17261685 N3587QBerger Donald D · Ilwaco, WABuilt 1973 · S/N 17261687 N3587XFlynn Sean C · Torrance, CABuilt 1968 · S/N 680156 N3588PLewis' Flying & Maintenance Svc Inc · Morse, LABuilt 1955 · S/N 18-4543 N3589Sale Reported · Lonoke, ARSale reported, pending cancellationBuilt 1970 · S/N 680 N3589KClark Joseph D · Kilgore, TXBuilt 1967 · S/N 28-23646 N3589PNewsom Bearden And Cobb Inc DBA · Lubbock, TXBuilt 1955 · S/N 18-4544 N3589QHalfpap Rodney J · Quincy, ILBuilt 1973 · S/N 17261689 N358CFApm Leasing LLC · Casper, WYBuilt 1978 · S/N 44-7995115 N358MMatuska Douglas G · Kent, WABuilt 1999 · S/N 20913 N358RWHawley Elizabeth B · Wichita Falls, TXBuilt 1979 · S/N AA5B1066 N358WGenco Holdings LLC Series A · Corpus Christi, TXBuilt 1966 · S/N 3417 N3590PSoyars Thomas E · San Marcos, TXBuilt 1955 · S/N 18-4545 N3591FWolfe Robert G · West Columbia, SCBuilt 1970 · S/N 17259225 N3591RAwmr LLC · Conroe, TXBuilt 1970 · S/N 28-5704

Back to AD 79-10-03 R2