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.

N903CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8327 N903FCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842175 N903KCHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1991 · S/N 1640 N903NSAmerican Patrols Inc · Midland, TXBuilt 1976 · S/N 17267441 N903SDWernli Donald R · Perry, IABuilt 2003 · S/N 2437 N903USSchneider Charles · Sioux Falls, SDBuilt 1966 · S/N 28-3068 N9040JEllis James E Trustee · Harvard, MABuilt 1966 · S/N 28-3070 N9040KGidden Aviation LLC · Katy, TXBuilt 1977 · S/N 28-7816186 N9040PMcclure Jared · Claremore, OKBuilt 1988 · S/N 1152 N9041DHamlin Ryan C · Naples, MEBuilt 1958 · S/N 22-6179 N9042DGage Ricky D · Lewiston, IDBuilt 1958 · S/N 22-6180 N9042HSt Pete Aviation Services LLC · St Petersburg, FLS/N 17265914 N9042JRenfroe Charles R · Panama City, FLBuilt 1966 · S/N 28-3073 N9042QTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 1976 · S/N 172-67996 N9043HPinter Seth K · Abbotsford, WIBuilt 1975 · S/N 17265915 N9043JHunter Lauchlin S Jr · Alexander City, ALS/N 28-3074 N9044DArctic Backcountry Flying Service LLC · Kotzebue, AKBuilt 1958 · S/N 18-6788 N9044FFiggins Matthew J · Stewardson, ILBuilt 1976 · S/N 28-7790277 N90450Air & Sea Leasing Inc · Cahokia, ILBuilt 1981 · S/N 0120 N90459Maness William A · North Pole, AKBuilt 2008 · S/N 1-1 N9045DLewis Elijah J · Luthersville, GABuilt 1958 · S/N 22-6183 N9045JLandsgaard Theodore · Rosamond, CABuilt 1966 · S/N 28-3076 N9045KHounslow Michael L · Rockville, MDBuilt 1977 · S/N 28-7890173 N90462Manning Mark D · Wrenshall, MNBuilt 1959 · S/N 325 N9046QDavis John A · Eau Claire, WIS/N 28-7125089 N9047DHansen Bailey · Juneau, AKBuilt 1958 · S/N 22-6186 N9047JHalajian Dominic M · Rogers, MNBuilt 1966 · S/N 28-3078 N9047LDaniel Bryan G · Childress, TXS/N 217-70 N9047YWeiss Michael F · Wyckoff, NJBuilt 1970 · S/N 18-8907 N9048HGravesen Mark A · Kenmare, NDBuilt 1975 · S/N 17265917 N904CCAlex Theodore P · Washington Depot, CTBuilt 1999 · S/N 9904CC N904DCGriswold Ryan M · Vista, CABuilt 2004 · S/N 90107 N904KJKlima Kenneth N · Greendale, WIBuilt 2010 · S/N 91201 N904PWJax Beach Aviation LLC · Jacksonville, FLBuilt 1968 · S/N 17257275 N904RAJw Aero Holdings Inc · Canandaigua, NYBuilt 1976 · S/N 17267060 N904UAlaskas Untamed Adventures LLC · Soldotna, AKBuilt 1974 · S/N 18-7409123 N904XCHarmon Philip E · Clifton, TXBuilt 2009 · S/N 84096 N9050JHunt-Thorton Trevon · Aurora, COBuilt 1966 · S/N 28-3081 N9051BFinished Work Aviation LLC · Redding, CAS/N 7FC-139 N9051FMccambridge Michael · Pacific Grove, CAS/N 18-2519 N9052JLairmore John H · Owasso, OKBuilt 1966 · S/N 28-3083 N9052LOlson Ronnie E · Palmer, AKBuilt 1970 · S/N 271-70 N9053JThompson Scott C · Redwood City, CABuilt 1966 · S/N 28-3084 N9053MMclellan James W · Phoenix, AZBuilt 2008 · S/N 11381 N9053USmart Tim · Spurger, TXBuilt 1987 · S/N 0658 N9054DWalsh Peter F · Hillsborough, NCBuilt 1982 · S/N 100 N90558Hagele Aviation LLC · Hillsboro, ORS/N 17274773 N9056YThompson Dennis E · Anchorage, AKBuilt 1980 · S/N 0001 N9057HAmoroso Ricardo C · Powder Springs, GABuilt 1975 · S/N 17265921 N9057JBaker Charles L · Swartz Creek, MIFirst renewal noticeBuilt 1966 · S/N 28-3091

Back to AD 80-04-03 R2