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.

N55320Dragon Flight Training Academy LLC · Pembroke Pines, FLBuilt 1981 · S/N 17275157 N55325Hater Michael A · Cincinnati, OHBuilt 1981 · S/N 17275158 N55327Grise Paul R · Hopkinsville, KYBuilt 1973 · S/N 28-7305362 N5532UGorman Jeremy J · Chapman, KSBuilt 1969 · S/N 28-26249 N55338Pt Arts LLC · Grand Rapids, MIBuilt 1973 · S/N 28-7325370 N5533FCopenhaver Ralph L · Brady, TXBuilt 1968 · S/N 28-24876 N5533QBoldt Matthew Frederick · Santa Fe, NMBuilt 1965 · S/N 2955 N5533RThompson Aaron R · Louisville, KYS/N 172RG0072 N55340Air55 LLC · Charleston, WVBuilt 1973 · S/N 28-7305363 N55342Dienwiebel Thomas · Santa Cruz, CAS/N 1183 N55349Mob Aviation LLC · Auburndale, FLS/N 17275163 N5534ELindsey Kelly M · Throckmorton, TXBuilt 1978 · S/N 17271883 N5534KAerolife Aviation LLC · Knox, INBuilt 1978 · S/N 1028-78 N5535FTrent Donald R · Rustburg, VABuilt 1968 · S/N 28-24934 N5535MButz Jonathan O · Mansfield, OHBuilt 1967 · S/N 121 N5535QJohnson Bar Inc · Pensacola, FLBuilt 1965 · S/N 2956 N55364Cremel Roberto J · Trumbull, CTS/N 28-7325384 N5536EJeffries And Hendley LLC · Greenwood, INBuilt 1978 · S/N 17271885 N5536FArnt James R Jr · Worthington, MNBuilt 1968 · S/N 28-24935 N5536PGryhon Designs · Camden, SCBuilt 1958 · S/N 24-600 N5536UPittman Discover Flight LLC · Oshkosh, WIBuilt 1969 · S/N 28-26257 N5536WSchilke Kenneth · Imperial, NES/N 28-626 N55372Mccarroll Daniel C · Saint Augustine, FLS/N 1188 N55374American Patrols Inc · Midland, TXBuilt 1981 · S/N 17275170 N5537MWiglesworth David G · Lenexa, KSBuilt 1967 · S/N 123 N5537PField Gerard · Middleboro, MABuilt 1958 · S/N 24-601 N5537RBalady Nabih · Santa Clarita, CABuilt 1979 · S/N 172RG0073 N55380Clark Joseph David · Kilgore, TXS/N 28-7325388 N55383Winkelman James R · Zionsville, INBuilt 1973 · S/N 28-7305371 N55386Redlands Flying Club · Redlands, CAS/N 1189 N5538ARado Robert L · Petersburg, MIBuilt 1952 · S/N 20-944 N5538KHilowitz Andrew J · Anchorage, AKBuilt 1978 · S/N 1045-78 N5538UAircraft Sales LLC · Caledonia, MIBuilt 1969 · S/N 28-26260 N55392Fast Aircraft Aerowork Corp · Fort Lauderdale, FLNon-citizen corporation, flight hours not reportedBuilt 1973 · S/N 28-7325391 N55397Stephens Ryan L · Gardner, ILBuilt 1973 · S/N 28-7305374 N55398Three Wire LLC · Portland, ORBuilt 1981 · S/N 17275174 N5539ASchneider Benjamin J · Wheeling, WVS/N 20-945 N5539FAeronautical Technical Service Inc · Collierville, TNBuilt 1968 · S/N 28-24938 N5539QJostad Leo D · Bottineau, NDBuilt 1965 · S/N 2958 N5539UDickey Blaine K · Marion, ARBuilt 1969 · S/N 28-26261 N553APAviation Paradise LLC · Homestead, FLBuilt 1980 · S/N 17274554 N553BCCarlson Robert A · Red Wing, MNBuilt 2001 · S/N 2171 N553FLWalters Rande L Sr · Lock Haven, PABuilt 1971 · S/N 28-7125392 N553MBBickling Melvin T · Johnstown, COBuilt 2011 · S/N 91457 N553PCSaint Louis University · St Louis, MOBuilt 2001 · S/N 4496072 N553PGAnderson Adam Z · Bay City, MIBuilt 2005 · S/N 2318 N553PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842090 N553SFSmith Nancy R · Duluth, MNBuilt 1966 · S/N 247 N553TPOakland Flyers LLC · Oakland, CABuilt 1975 · S/N 28-7690105 N55401Keesling Roger · Starkville, MSBuilt 1973 · S/N 28-7325405

Back to AD 79-10-03 R2