Registered aircraft · 40,394

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.

N9849GPray Aviation Inc · Augusta, KSFirst renewal noticeBuilt 1971 · S/N 17259749 N9849LDynasty Adventure Inc · Wilmington, DEBuilt 1986 · S/N 17276637 N9849QBriggs Christopher T · Manchester, NHBuilt 1975 · S/N 17265793 N9849WKauenhofen Jacobo DBA · Boley, OKBuilt 1967 · S/N 28-23361 N984CTMorinaka Noble · Nyssa, ORBuilt 2021 · S/N 11317 N984FAFreedom Aviation Inc · Lynchburg, VABuilt 1971 · S/N 17259928 N984RSAnderson John C · Lake Geneva, WIBuilt 2005 · S/N 60056 N984SWWaits Paul C · Blanchard, OKBuilt 1969 · S/N 28-5415 N984THBadenhope John R · Greeneville, TNS/N 2002 N98502Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1985 · S/N 17276302 N9850UHagan Kenton Lee · Fayetteville, ARS/N AA5A0250 N9850VPropability One LLC · Daytona Beach, FLBuilt 1974 · S/N 17264532 N9850WDestination Flyer LLC · Memphis, TNBuilt 1967 · S/N 28-23362 N9851DSkarda Flying Service Inc · De Valls Bluff, ARS/N 18-6931 N9851UPaul Brian K · San Angelo, TXBuilt 1976 · S/N AA5A0251 N98525Trns Solutions LLC · Lewes, DEBuilt 1984 · S/N 17276306 N9852UWilkening Robert E · Mesa, AZBuilt 1976 · S/N AA5A0252 N9853GParker Steve E · Palmer, AKBuilt 1971 · S/N 17259753 N9853JEastern Kentucky University Center For Aviation · Richmond, KYBuilt 1980 · S/N 17273937 N9853LTrend Vector Aviation Int · Barrigada, GUBuilt 1986 · S/N 17276639 N9853USherwin Robert A · Redondo Beach, CABuilt 1976 · S/N AA5A0253 N9853WReynolds Stuart N II · Sutherland, VABuilt 1967 · S/N 28-23366 N9854UPatterson James B · Euless, TXBuilt 1976 · S/N AA5A0254 N9854WPerry Michael · Wilmer, ALBuilt 1967 · S/N 28-23367 N9855DMcghan Construction Co Inc · Big Lake, AKBuilt 1959 · S/N 18-6936 N9855GChoctaw Nation Of Oklahoma · Durant, OKBuilt 1971 · S/N 17259755 N9855SAri Ben Aviatior Inc · Fort Pierce, FLBuilt 2002 · S/N 2842151 N9855UGlennon John J · Holland, MABuilt 1976 · S/N AA5A0265 N9855WWilliamson Flying Club Inc · Williamson, NYBuilt 1967 · S/N 28-23369 N98561Blue Sky Flight Training LLC · Hamilton, OHBuilt 1985 · S/N 17276309 N9856UBuell Scott T · Floral City, FLBuilt 1976 · S/N AA5A0256 N9857GLeaseair LLC · Wilmington, DEBuilt 1971 · S/N 17259757 N98584Albritton Montana D · Honolulu, HIS/N 17276316 N9858DBucklin Calvin W · Great Falls, MTBuilt 1959 · S/N 18-7026 N9858GRegistration Pending · Dublin, VARegistration pendingBuilt 1971 · S/N 17259758 N9858PBentley Aero Inc · Wilmington, DEFirst renewal noticeS/N 18-7709006 N9858WPearce Ronald M · Madison Heights, MIBuilt 1967 · S/N 28-23372 N9859GLandrum Craig L · Vinita, OKBuilt 1971 · S/N 17259759 N9859PBirdwood Creek Holding LLC · Elkhorn, NEBuilt 1979 · S/N 18-8009029 N9859VClayton Jeff · Ivy, VABuilt 1975 · S/N 17264535 N9859WBerry Meredith W III · Covington, LABuilt 1967 · S/N 28-23374 N985ACRainey Aerial Ag Service Inc · Obion, TNBuilt 2004 · S/N 463-2004 N985CGCole Gregory E · Mechanicsville, MDBuilt 1998 · S/N 24689-3JW N985DMSanve Karl · Elk City, OKBuilt 1994 · S/N 20009C N985EAStich David · Casper, WYBuilt 1958 · S/N 55077 N985FAFreedom Aviation Inc · Lynchburg, VABuilt 1975 · S/N 17265991 N985KARegistered aircraftBuilt 1968 · S/N 17257703 N985MSSteele William G · Warrenton, VABuilt 1987 · S/N 1787 N985RVGoodrich Matthew · Apple Valley, CABuilt 2010 · S/N 603-3 N985WWuya Charlene F · Bethel, AKBuilt 1961 · S/N 18-7609

Back to AD 79-10-03 R2