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.

N80881Bizzjet Inc · Kalispell, MTBuilt 1946 · S/N 284 N80884Rein W Clark · Ottawa, KSBuilt 1976 · S/N 17266788 N8088CVouk Frank E · Firth, IDBuilt 1954 · S/N 18-3495 N80896Dsr-Cherokee 180 LLC · Dallas, TXBuilt 1976 · S/N 17266793 N8089CNelco Farms Inc · Fairfield, IAS/N 28-7690102 N8089ESkywarrior Flight Training Inc · Pensacola, FLBuilt 1978 · S/N 17272138 N8089PBerryhill Daniel R · Darwin, MNBuilt 1963 · S/N 24-3337 N8089WBrind F Alan · Ionia, NYFirst renewal noticeBuilt 1965 · S/N 28-2180 N808BWWeber William A · Brodhead, WIBuilt 1962 · S/N 7GCB-147 N808DCWaters John Klas · San Marcos, CABuilt 1976 · S/N 28-7690456 N808DJAeroquest LLC DBA · Olive Branch, MSBuilt 1982 · S/N ME-391 N808GJWait Kyle L · Palmer, AKBuilt 2005 · S/N 204 N808KASchlomer Lyle M · Osseo, WIS/N 28-4583 N808PWederski Lonnie E · Yarnell, AZBuilt 1986 · S/N 1044 N808RKGoehl Jeffrey A · College Station, TXBuilt 1974 · S/N 28-7415225 N808UFMahoney Clinton D · Tecumseh, NEBuilt 1975 · S/N 17264869 N80903Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1946 · S/N 306 N80906Red Door Aviation LLC · Dover, DEBuilt 1976 · S/N 17266796 N80908International Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 28-8016074 N80909Kirkman Todd · Port Charlotte, FLBuilt 1946 · S/N 312 N8090ELeslie H Mcelhany DBA · Watertown, SDBuilt 1979 · S/N 28-8016072 N8090FDouglas Malik · Mcdonough, GABuilt 1976 · S/N 28-7790233 N8090LWilliams Chris B · Reno, NVBuilt 1979 · S/N 28-8090092 N80912Bay Area Concrete LLC · Hayward, CABuilt 1976 · S/N 17266798 N80914Cp Aviation Inc · Santa Paula, CABuilt 1976 · S/N 17266799 N8091DJohnston Zach H · Soldotna, AKS/N 18-6086 N8091EChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 172-75486 N8091RParis Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-8016077 N8091WClement Timothy S · Skidmore, MOS/N 28-2182 N8091XBlack Hunter F · Blanding, UTBuilt 1966 · S/N 28-21777 N8091YStevens Charles R · Williamsburg, MIBuilt 1979 · S/N 28-8016079 N80921Conerly Group LLC · Denham Springs, LABuilt 1976 · S/N 17266803 N80926Flight Leasing Corp · Wilmington, DEBuilt 1979 · S/N 28-8090098 N80928Bellingham Aviation Services LLC · Bellingham, WABuilt 1976 · S/N 17266804 N8092ERaleigh Flying Club LLC · Chapel Hill, NCBuilt 1979 · S/N 28-8090093 N8092GEarly Stephen · Sharpsburg, GABuilt 1979 · S/N 28-8090095 N8092HUnited States Air Force Owner · Hanscom Afb, MABuilt 1979 · S/N 28-8016082 N8092NCash Management Consulting LLC · Granite Springs, NYBuilt 1968 · S/N 28-25335 N8092WDidea Aviation LLC · Orlando, FLBuilt 1965 · S/N 28-2183 N80931Augusta Aviation Inc · Augusta, GABuilt 1976 · S/N 17266806 N80934Cogelia Joseph M · Winchester, VABuilt 1979 · S/N 28-8090105 N8093DSmith Ihler M · Fairbanks, AKBuilt 1957 · S/N 18-6084 N8093GFargo Jet Center LLC · Fargo, NDBuilt 1979 · S/N 28-8090100 N8093HSarraf Majid · Aliso Viejo, CABuilt 1979 · S/N 28-8090101 N8093NSaraland High School · Saraland, ALS/N 28-25336 N80941Holombo Ray J · Taylors, SCBuilt 1976 · S/N 17266810 N8094NEggan Mark A · Lee Center, NYBuilt 1968 · S/N 28-25337 N8094QSpitzer Helicopter LLC · Woodland Hills, CABuilt 1993 · S/N 2385 N8094WMatney Tara · Abingdon, VABuilt 1965 · S/N 28-2188 N80952Registered aircraftBuilt 1976 · S/N 17266817

Back to AD 79-10-03 R2