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.

N9902YJeepers LLC · New York, NYBuilt 1961 · S/N 8 N9903VDwh Flight LLC · Spring, TXBuilt 1974 · S/N 17264552 N99040Bradley Aircraft Company LLC · Columbus, INBuilt 1985 · S/N 17276395 N99045Allen Michael R · Graham, NCBuilt 1985 · S/N 17276396 N99048Bradley Aircraft Co · Columbus, INBuilt 1976 · S/N 17268367 N9904QStanford Jay J · Saint Marys, GABuilt 1975 · S/N 17265848 N9904RInnis Alfonso R Inc · Wilmington, DES/N TD-374 N9904VStratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17264553 N9904WTraweek Parrish C · San Manuel, AZBuilt 1967 · S/N 28-23424 N9905QCentral Air Service · Lewistown, MTBuilt 1975 · S/N 17265849 N9906LRiseaero LLC · Florence, SCBuilt 1986 · S/N 17276647 N9906UBerger Stanley F · Saint Paul, MNBuilt 1977 · S/N AA5A0306 N9906WBelmont Thomas M · Boca Raton, FLBuilt 1967 · S/N 28-23426 N9906YMac · Wichita, KSBuilt 1961 · S/N 7GCB-74 N9907QPlasco Designs Of Arkansas Inc · Texarkana, ARBuilt 1975 · S/N 17265851 N9907YIngle Stephen D · Bainbridge, OHBuilt 1961 · S/N 94 N9908KG&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 28-7890198 N9908UVajdak Ronnie · Wallingford, CTBuilt 1977 · S/N AA5A0308 N9908YNickerson William L · Libby, MTBuilt 1962 · S/N 122 N9909QCk Aviation LLC · Charlestown, INBuilt 1975 · S/N 17265853 N9909UDibble Robb A · Kirkland, WABuilt 1977 · S/N AA5A0309 N9909WVafaie Frederick · Williston, FLBuilt 1967 · S/N 28-23429 N990BFlight Academy LLC · Van Nuys, CABuilt 1978 · S/N 17272059 N990DSRegistered aircraftBuilt 2003 · S/N 5331 N990PHSanchez Leonides R · Alton, ILBuilt 1965 · S/N 28-2797 N990SAOn-Site Aviation Inc · Hillsboro, NDBuilt 1974 · S/N 31-74 N990VTWang Jinrao · Peachtree City, GABuilt 1969 · S/N 28-25910 N990XDl Industries Inc · Claremont, NHBuilt 1968 · S/N 28-5251 N99100Sterling Flight Training LLC · Jacksonville, FLBuilt 1985 · S/N 172-76401 N99104Dury Aviation Services Inc · De Soto, ILBuilt 1985 · S/N 17276403 N9910DMoe Gregor A · Sarasota, FLFirst renewal noticeBuilt 1959 · S/N 18-6951 N9910QTevebaugh Dennis J · Elkhart, KSBuilt 1975 · S/N 17265854 N9910USky West Aviation Inc Trustee · Albuquerque, NMS/N AA5A0310 N9910YBaumgartner Larry C · Roseau, MNBuilt 1962 · S/N 7GCB126 N9911QAeronautical Technical Service Inc · Collierville, TNS/N 17265855 N9911USandlapper Venutures Inc · Walhalla, SCBuilt 1977 · S/N AA5A0311 N9911WCategory One Aviation LLC · Atascadero, CABuilt 1967 · S/N 28-23433 N9911YTyrrell Luke L · Fairbanks, AKS/N 120 N9912LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276648 N9912QKd Aviation LLC · Sheridan, WYBuilt 1975 · S/N 17265856 N9913UThomason David F · Poplar Grove, ILBuilt 1977 · S/N AA5A0313 N9913WJcl Equipment Rental · Coleta, ILBuilt 1967 · S/N 28-23434 N9914ESimica Charles A · Marietta, GABuilt 1979 · S/N 17272288 N9914QVictor Aviators Inc · Kernersville, NCBuilt 1975 · S/N 17265858 N9914SSheffield Robert A · Mooresville, NCBuilt 1967 · S/N 28-23672 N9914WYellow Bird Flying Club · Toledo, OHBuilt 1967 · S/N 28-23435 N9914YKnapper Jack A · Hibbing, MNBuilt 1961 · S/N 7GCB-112 N99157Hess Garrett J · Fullerton, CABuilt 1985 · S/N 17276412 N9915BTaro Investment LLC · Doral, FLBuilt 1982 · S/N 172RG1078 N9915UBest Oren · Sunfield, MIBuilt 1977 · S/N AA5A0315

Back to AD 80-04-03 R2