Registered aircraft · 40,396

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.

N6546UBadlands Flyers Inc · Watford City, NDBuilt 1962 · S/N 2329 N6547JMeyer Mark A · Vass, NCBuilt 1968 · S/N 28-4990 N6547SMiller Bradley J · Joliet, MTS/N 15067347 N6547WMacclements Jonathan E · Austin, TXBuilt 1965 · S/N 28-20626 N65489Flight Solutions LLC · Columbia, MOBuilt 1982 · S/N 17275762 N6548ESewell William G Jr · Bremen, GABuilt 1978 · S/N 17272036 N6548JInspire Aviation LLC · Magnolia, TXBuilt 1968 · S/N 28-4992 N6549DBbjs Investments LLC · Waukesha, WIBuilt 1979 · S/N 17272858 N6549JHuff Glenn N · Hackettstown, NJFirst renewal noticeBuilt 1968 · S/N 28-4993 N6549ZRivers Larry R · Talkeetna, AKBuilt 1962 · S/N 18-7879 N654ALMoore Howard · Camden, TNBuilt 1977 · S/N 17269033 N654BCCobb Charles J · Fallbrook, CABuilt 1969 · S/N 28-5335 N654CRLinde Rodney C · Weatherford, TXBuilt 2003 · S/N 80734 N654FLRoca Roja Y Caballo Gris De Idaho LLC · Meridian, IDBuilt 1971 · S/N 28-7125569 N654RTKonrad Melvin J · Cumming, IABuilt 1999 · S/N 24776 N654RVVan Hoff Eric J · Gunter, TXBuilt 2003 · S/N 1898 N654SHHutcherson David R · Gretna, VABuilt 2003 · S/N 3505 N654WMMillar Rick A · Anchorage, AKBuilt 2012 · S/N 001 N654YRVet Air LLC · San Juan, PRBuilt 1964 · S/N 28-1867 N65503Bentz Andreas · Falls Church, VABuilt 1983 · S/N M2378 N6550JJans Stanley E · Dakota City, NEBuilt 1968 · S/N 28-4994 N6550UGeorge Ladelle L · Ashley, NDBuilt 1963 · S/N 2333 N65516J-Airco LLC · Nashville, TNBuilt 1982 · S/N 17275769 N65518Tk Equipment LLC · Brownsburg, INBuilt 1982 · S/N 17275771 N6551LParker Kerry · Hobbs, NMBuilt 1974 · S/N AA5-0651 N6551UAuker Donald · Lebanon, PABuilt 1962 · S/N 2334 N6551WThull Stanley B · Freeport, MNBuilt 1965 · S/N 28-20631 N65525Sinha Nanda K · Benicia, CABuilt 1982 · S/N 17275774 N65528Jacks Charles D · Crowley, LABuilt 1983 · S/N 17275775 N6552FAir Planes LLC · Soddy Daisy, TNBuilt 1979 · S/N 17273239 N6552JCherokee Flyers Inc · Phoenixville, PABuilt 1968 · S/N 28-4997 N6552UGoldstein Meyer · Underwood, WABuilt 1962 · S/N 2335 N6553DLlv Aviation LLC · Wilmington, DEBuilt 1979 · S/N 17272861 N6553EZa Airport Rental LLC · Zanesville, OHBuilt 1978 · S/N 17272037 N6553FArcwin Aero LLC · New Palestine, INBuilt 1976 · S/N 28-7790154 N6553JCrestwater Properties LLC · Florence, SCBuilt 1968 · S/N 28-4998 N6553KSchaffner Christopher · Dunmore, WVBuilt 1980 · S/N 17274211 N6553RRenkenberger Paul H · Yucaipa, CABuilt 1975 · S/N MB-744 N6553ULewis Orville W II · Memphis, TNBuilt 1962 · S/N 2336 N6554CCharles City Aeronautics Inc · Charles City, IABuilt 1978 · S/N 28-7890383 N6554DHancock Jeffrey D · Delta, COBuilt 1979 · S/N 17272862 N6554WTpc Air LLC · Colleyville, TXBuilt 1965 · S/N 28-20634 N6555JTeton Leasing LLC · Pocatello, IDBuilt 1980 · S/N 17273890 N6555PBig Wings Inc · Delavan, MNBuilt 1959 · S/N 24-1091 N6555WDeeter George E · Chillicothe, OHBuilt 1965 · S/N 28-20636 N6556BLewis Joseph M · Huntington Beach, CAFirst renewal noticeBuilt 1958 · S/N 1226 N6556HRyco LLC · Lusk, WYBuilt 1975 · S/N 17265486 N6556JJabco Inc · Weston, IDBuilt 1968 · S/N 28-5002 N6556UQoc Innovations LLC · Fall River, WIBuilt 1962 · S/N 2339 N6556WMontagnino James A · Saratoga Springs, NYBuilt 1965 · S/N 28-20637

Back to AD 79-10-03 R2