Registered aircraft · 40,471

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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N9721KJet Time Consulting LLC · Gilbert, AZBuilt 1976 · S/N 28-7690277 N9721UWood Lisa L · Wrightsville, PABuilt 1976 · S/N AA5A-0121 N9721WCarson Bradley · Shippensburg, PAS/N 28-23199 N9722DLincoln Land Community College · Springfield, ILBuilt 1959 · S/N 22-6634 N9722HQuad Cities Aero LLC · Bettendorf, IABuilt 1975 · S/N 17266335 N9722JRegistration Pending · Missoula, MTRegistration pending, pending cancellationBuilt 1967 · S/N 28-3914 N9722NBaker Robert A · Salcha, AKBuilt 1952 · S/N 18-1685 N9722VTck Services LLC · Millington, MIBuilt 1974 · S/N 17264488 N9723HFlying Tigers Flight School LLC · Houston, TXBuilt 1975 · S/N 17266336 N9723JRegistered aircraftBuilt 1967 · S/N 28-3915 N9724KGoodwin Thomas R · Martinsville, INBuilt 1976 · S/N 28-7690278 N9724PWestcott Brett M · Wasilla, AKBuilt 1975 · S/N 18-7609003 N9724QRegistered aircraftBuilt 1970 · S/N M-1306 N9725DSantine Michael F · Shelby Township, MIBuilt 1959 · S/N 22-6637 N9725JSturgeon Aviation LLC · Ellijay, GABuilt 1967 · S/N 28-3917 N9725LLeading Edge Aviation LLC · Manchester, MOS/N MB-515 N9725POldham Kris Dean · Anchorage, AKBuilt 1975 · S/N 18-7609004 N9725QWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17265787 N9725UHubbard George E · Philadelphia, PABuilt 1976 · S/N AA5A-0125 N97266East Hill Flying Club · Ithaca, NYBuilt 1984 · S/N 17276169 N97269J&L Aviation LLC · Malta, NYBuilt 1984 · S/N 17276170 N9726PInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 18-7609005 N9726WSarratt Curtis H · Annapolis, MDBuilt 1967 · S/N 28-23204 N9727JJdc Aviation LLC · Upland, CABuilt 1967 · S/N 28-3920 N9727LWiseman Holdings Group LLC · Clermont, FLBuilt 1971 · S/N MB-521 N9727PCoggins Craig C · Nome, AKS/N 18-7609006 N9727VDills John H · Ione, WABuilt 1974 · S/N 17264492 N9727WGrinter Mark R · Highland, ILS/N 28-23205 N9728DGrizzly Skins Of Alaska Inc · Wasilla, AKBuilt 1959 · S/N 22-6640 N9728UGrrumman LLC · Salem, ORBuilt 1976 · S/N AA5A-0128 N9729DBurr Industries Inc · Keystone Heights, FLBuilt 1959 · S/N 22-6641 N9729LStephen Christina J · Shreveport, LAS/N M-1356 N9729UDriscoll Cindy M · Savannah, TNBuilt 1976 · S/N AA5A-0129 N9729WArtesian Hills Aviation LLC · Twin Lake, MIBuilt 1967 · S/N 28-23207 N972CPlainfield Aviation Inc · Plainfield, ILBuilt 2002 · S/N 2843538 N972CAKleinschnittger Steven J · Alton, ILBuilt 1966 · S/N 28-3209 N972DPCrosswind Aviation Of Oklahoma LLC · Stillwater, OKBuilt 1969 · S/N 17258652 N972FCBlackhawk Holding Corp · Wilmington, DEBuilt 1979 · S/N 17272682 N972NCIal Corp · Lewes, DEBuilt 1971 · S/N 17259818 N972PMNp Aviation Inc · Naguabo, PRS/N 17264940 N9730DFlood Ashley · Gibbstown, NJBuilt 1959 · S/N 22-6642 N9730LSundowner N9730l LLC · Calhoun, GABuilt 1971 · S/N M-1357 N9730PDreger Dean R · Wilbur, WABuilt 1975 · S/N 18-7609007 N9730USherry-Aire LLC · Sidney, MTBuilt 1976 · S/N AA5A-0130 N9730VWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264494 N97313Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276177 N9731HCreative Strategies Inc · Proctorville, OHS/N 17266339 N9731LMaine Instrument Flight · Augusta, MEBuilt 1971 · S/N M-1358 N9731UNatale Louis H · Cedar Park, TXBuilt 1976 · S/N AA5A-0131 N9731WDacy David M · Harvard, ILBuilt 1967 · S/N 28-23210

Back to AD 80-04-03 R2