Registered aircraft · 40,396

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.

N7276WFlyright Aviation LLC · Plymouth, MNBuilt 1963 · S/N 28-1114 N7277WOrganic Media Studio LLC · Hattiesburg, MSBuilt 1963 · S/N 28-1146 N7278DAugustin Caleb J · Madison, ALS/N 18-5691 N7278PGabrielson Guy G III · Peabody, MABuilt 1961 · S/N 24-2454 N7279PWestrand Jeffrey C · Amboy, WAS/N 24-2455 N727ACLong Island Aviators LLC · Seaford, NYBuilt 1977 · S/N 28-7890128 N727AJMeyer Joshua · Fairborn, OHBuilt 1968 · S/N 28-24624 N727BHPiper 7bh LLC · Middleton, MABuilt 1974 · S/N 28-7415464 N727DCCalianno David · Spring Hill, FLBuilt 1974 · S/N 17702086 N727DDAlba Aviation Services Inc · Scottsdale, AZBuilt 2002 · S/N 3328 N727DEKennett Aerospace LLC · Kennett, MOBuilt 1978 · S/N 28-7816572 N727FLOgilvie Danny L · Yucca Valley, CABuilt 1972 · S/N 28-7225431 N727GAPreston Richard R Trustee · Albuquerque, NMBuilt 1978 · S/N GA7-0026 N727HYTranstrum Monte Kay · Saint Charles, IDBuilt 2003 · S/N 2247 N727JBjdr Aero Corp · Wilmington, DEBuilt 1968 · S/N 680113 N727JFFlleurent John P · Stratham, NHBuilt 1998 · S/N 80551 N727LFLanier Equipment Leasing LLC · Gainesville, GABuilt 1978 · S/N 44-7995197 N727LGYouth & Aviation Inc · Thiensville, WIBuilt 1968 · S/N 17256938 N727METruesdell Shannon · Stephenville, TXBuilt 1976 · S/N 17268426 N727PANorat Richard N V · Kerrville, TXBuilt 1967 · S/N 670097 N727PMMiddlebrook Paul E · Penn Yan, NYBuilt 1981 · S/N 17275485 N727RStyer David L · Mount Gilead, OHS/N 212191 N727RCKelley Aircraft LLC · Weyers Cave, VABuilt 1974 · S/N 17263887 N727SFRenko Steven E · Elmira, NYBuilt 1968 · S/N 17256791 N727TDLean Aviation LLC · Saint Augustine, FLBuilt 1970 · S/N 18-8909 N727TLLangebrake Lawrence C · Saint Petersburg, FLBuilt 1977 · S/N 17269372 N727TMModesto Vapor Trails · Modesto, CABuilt 1979 · S/N AA5B1178 N727TSStreng Terry E · Columbus, OHBuilt 1973 · S/N 17262367 N727WMMd Air Ops LLC · High Springs, FLS/N MB-799 N7280CGriff Air LLC · Aurora, ORBuilt 1975 · S/N 28-7625074 N7280DLavin Gregory S · Chugiak, AKBuilt 1957 · S/N 18-5693 N7280FHarmon Sharon O · Pasco, WAFirst renewal noticeBuilt 1968 · S/N 28-25192 N7281DMartin Michael J · Anchorage, AKBuilt 1957 · S/N 18-5695 N7281JBilbrey Don R · Georgetown, OHBuilt 1968 · S/N 28-24626 N7282JWirth Alan Patrick · Callaway, MDBuilt 1968 · S/N 28-24629 N7282WHoracio Marcelo Knop · Hialeah, FLS/N 28-1122 N7284GFisher Global LLC · Faulkner, ARBuilt 1970 · S/N 17258984 N7284JGiermek Peter T · Olean, NYBuilt 1968 · S/N 28-24631 N7284LGriffin Alvin G · Mechanicsville, MDBuilt 1972 · S/N AA5-0284 N7285FKulp Clayton H · Wichita, KSS/N 28-25198 N7285LMurrell David Tyler · Pensacola, FLBuilt 1972 · S/N AA5-0285 N7286LCover George A · Thayer, MOBuilt 1972 · S/N AA5-0286 N7286QLacombe Bryan K · Rockwall, TXBuilt 1972 · S/N 17260586 N7286WMy Bird Is Bigger Than Yours LLC · Fort Myers, FLBuilt 1963 · S/N 28-1126 N7287GTen Mile Ranch Inc · Vale, ORBuilt 1970 · S/N 17258987 N7287JJames Leroy R · Renfrew, PABuilt 1968 · S/N 28-24638 N7287PTwo Dot Aircraft LLC · Kalispell, MTBuilt 1961 · S/N 24-2465 N7287WLebouef Kelly J · Rayne, LABuilt 1963 · S/N 28-1131 N72884Hawkeye Aviation LLC · Miami, FLBuilt 1974 · S/N 17264315 N7288FJ&S Aeronautics LLC · Mcgregor, TXBuilt 1968 · S/N 28-25202

Back to AD 79-10-03 R2