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.

N629AKCloward Marc D · Cordova, AKBuilt 1951 · S/N 18-122 N629APThomas Lucas G · Beebe, ARBuilt 1978 · S/N 266-78 N629BWagner Nathan D · Dane, WIBuilt 1997 · S/N 5108 N629EMMelendez Carlos M · Saint Petersburg, FLBuilt 2018 · S/N 001 N629FTFlorida Institute Of Technology · Melbourne, FLBuilt 2001 · S/N 2842132 N629GKTumenas Daniel E · Girdwood, AKS/N 001 N629GWPage Cathleen A · Tucson, AZBuilt 1994 · S/N 23072 N629HBBattle Creek Powersports LLC · Jasper, TNBuilt 1958 · S/N 23-1527 N629JMWebster Bart H · Queen Creek, AZFirst renewal noticeBuilt 2003 · S/N 2232 N629KHarrill Roy K · Columbia, SCBuilt 2002 · S/N 23917 N629MBBelleau Clifford D · Anchorage, AKBuilt 2000 · S/N TRB-003 N629MMMcgraw Michael T · Gainesville, GABuilt 1973 · S/N 17262164 N629PKJones John Michael · Oologah, OKBuilt 2002 · S/N 1326-2002 N62AMOlson Ronnie E · Palmer, AKBuilt 1991 · S/N 002AM N62ATSelby Kevin L · Stark City, MOBuilt 1980 · S/N 1013 N62BHHennings Bobbie J · Fort Valley, GABuilt 1994 · S/N 20752 N62BKHarrington Patrick M · Clinton, MSBuilt 2000 · S/N 2909 N62CBMayer David J · Ingleside, ILS/N 121 N62CFHolochwost Anthony T · Auburn, CABuilt 1962 · S/N 2197 N62CLConklin Christopher S · Oshkosh, WIBuilt 1977 · S/N AA5B0470 N62CSWhitcher Garrick L · Woodburn, ORS/N 14M N62DFBuffkin Peter E Jr · De Soto, KSBuilt 2004 · S/N 2268 N62DXGlasford John T · Rapid City, SDBuilt 1962 · S/N 2187 N62EAZurawski Joseph · Ocala, FLBuilt 2012 · S/N 1035 N62EEJuengel Jeremy A · Cheyenne, WYBuilt 2009 · S/N 21691 N62ERMantiply Paul · Columbia, CABuilt 1979 · S/N AA5B1257 N62GKAugusta Flying Club Inc · Martinez, GABuilt 1978 · S/N 17271667 N62HYTheken Terry · Fountain, COBuilt 2004 · S/N 2258 N62JFAirtrade Aviation Corp · Lewes, DENon-citizen corporation, flight hours not reportedS/N 3922 N62LSSpera Louis A · Pueblo West, COBuilt 2003 · S/N 70772 N62MGBedsole James M · Eatonton, GABuilt 2001 · S/N 60517 N62PMRoberts James A · Hamburg, ARBuilt 1962 · S/N 2055 N62PSRegistration Pending · Wallace, CARegistration pendingBuilt 1993 · S/N 5291 N62RMEmployment Services Inc · Virginia Beach, VABuilt 1962 · S/N 28-352 N62RTLowell William · Caldwell, IDS/N 18-7609038 N62RWTofte Arthur Shawn · Lewis Center, OHS/N 1AC N62SLVerville Justin M · Lexington, KYBuilt 1994 · S/N 732320575 N62SMBell Charles S · Fort Payne, ALBuilt 1973 · S/N 17261862 N62TDCon Air LLC · Monument, COBuilt 1979 · S/N VAC-147-79 N62YRSnyder George H Trustee · Lake Worth, FLBuilt 1962 · S/N 2118 N6300JWoltman Roger · Cherokee, IABuilt 1968 · S/N 28-4709 N63014Taylor Daniel S · The Woodlands, TXBuilt 1981 · S/N 17275374 N63017Adams Aviation Services Inc Trustee · Wilmington, DEBuilt 1981 · S/N 17275377 N63019Althaver David B · Kearny, NJBuilt 1981 · S/N 17275379 N6301CMustang Aviation LLC · Orleans, NEBuilt 1978 · S/N 28-7890359 N6301DR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17272706 N6301EJc Air Academy Inc · Stockton, CAS/N 17272004 N6301JMorais Antonio L · Greenacres, WABuilt 1968 · S/N 28-4712 N6301WKap Title Inc · Tucker, GABuilt 1964 · S/N 28-20344 N6302FForrest Steven L · Wrangell, AKBuilt 1967 · S/N 17255486

Back to AD 79-10-03 R2