Registered aircraft · 275

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:76-13-11-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-13-11-R1') 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:76-13-11-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-13-11-R1')
  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:76-13-11-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-13-11-R1')
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.

N65824Barrett Jane T · Tehachapi, CABuilt 1973 · S/N 304 N65825Nevada Soaring Association Inc · Reno, NVBuilt 1973 · S/N 305 N65828Wurtsboro Airpark LLC · Wurtsboro, NYS/N 325 N65829Caprock Soaring Association · Lubbock, TXBuilt 1974 · S/N 326 N65833Harris Hill Soaring Corp · Horseheads, NYBuilt 1974 · S/N 313 N65834Robertson Boyd W · Brandon, MSBuilt 1974 · S/N 314 N65840Black Forest Soaring Society · Monument, COBuilt 1974 · S/N 330 N65843Delash John M · Williamson, GABuilt 1974 · S/N 333 N65846Civil Air Patrol Inc · Montgomery, ALBuilt 1974 · S/N 336 N65848North Carolina Soaring Association · Zebulon, NCS/N 341 N65849Louisville Soaring Club Inc · Lexington, KYBuilt 1974 · S/N 339 N65852Peterson Adam · Bakersfield, CAS/N 342 N65854Registration Pending · Spokane, WARegistration pendingBuilt 1974 · S/N 344 N65859Hobbs Soaring Society Inc · Hobbs, NMBuilt 1974 · S/N 347 N65863Lake Elsinore Soaring Club · Wildomar, CAS/N 348 N65865Irwin Luther J · Sahuarita, AZBuilt 1974 · S/N 350 N65867Soaring Tigers Inc · Princeton, NJBuilt 1974 · S/N 351 N65879Oklahoma Soaring Association · Mustang, OKBuilt 1974 · S/N 352 N65918Long Island Soaring Association · Shirley, NYBuilt 1974 · S/N 358 N65974Independence Glider Club · Independence, ORBuilt 1974 · S/N 354 N65976Jersey Ridge Soaring LLC · Blairstown, NJBuilt 1974 · S/N 356 N681UBishop Thomas W · Decatur, TXBuilt 1965 · S/N 217 N685UMaglaughlin Ronald D · Udall, KSBuilt 1965 · S/N 220 N694UCaprock Soaring Association · Lubbock, TXS/N 222 N695UMessner Dale A · Uniontown, OHBuilt 1965 · S/N 223 N7537Welch-Swett Theresa M · Zebulon, NCBuilt 1969 · S/N 167 N7539K&L Soaring LLC · Cayuta, NYBuilt 1970 · S/N 169 N7545Sky Sailing Inc · Warner Springs, CABuilt 1970 · S/N 175 N7546Stewarts Aircraft Service Inc · Waynesville, OHBuilt 1970 · S/N 176 N7547Sky Sailing Inc · Warner Springs, CABuilt 1970 · S/N 177 N7558Grand Canyon Flyers LLC · Flagstaff, AZBuilt 1970 · S/N 188 N7588Barrett Jane T · Tehachapi, CABuilt 1970 · S/N 190 N7589Civil Air Patrol · Montgomery, ALBuilt 1970 · S/N 189 N7591Kansas Schweizer Owners Organization LLC · Overland Park, KSBuilt 1970 · S/N 191 N7609Cooper Todd L · Hampton, NJBuilt 1970 · S/N 181 N767AESuperior Soaring LLC · Scottsdale, AZBuilt 1979 · S/N 554 N7686Valley Soaring Club Inc · Middletown, NYBuilt 1970 · S/N 171 N76SERegistration Pending · Peyton, CORegistration pendingS/N 187 N7701SCentral Ohio Soaring Assoc Inc · Marion, OHBuilt 1968 · S/N 121 N7757SBates Marcus L Jr · Leander, TXS/N 127 N7758SSpokane Soaring Society Inc · Spokane, WABuilt 1968 · S/N 130 N7761SSky Sailing Inc · Warner Springs, CAS/N 131 N7763SSky Sailing Inc · Warner Springs, CABuilt 1969 · S/N 135 N7764SWichita Soaring Association · Wichita, KSBuilt 1969 · S/N 134 N7766SCaldwell Bruce A · White Salmon, WAS/N 136 N7767SPrescott Area Soaring Inc · Prescott Valley, AZBuilt 1969 · S/N 137 N7772SJones Stephen C · Wadsworth, ILBuilt 1969 · S/N 147 N7773SWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1969 · S/N 143 N7776SFranconia Soaring Association · Franconia, NHBuilt 1969 · S/N 146 N7780SAndy Aviation Inc · Live Oak, FLBuilt 1969 · S/N 150

Back to AD 76-13-11 R1