OpenAirDocs.org
AD 76-14-07 R2

Registered aircraft · 930

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
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-14-07-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:76-14-07-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.

N9640TJohnson Joshua S · Lake Jackson, TXBuilt 1960 · S/N 57440N9642TDavidow Clifford A · Portland, ORBuilt 1960 · S/N 57442N9643TDunn Meghan Elizabeth · Mckinney, TXBuilt 1960 · S/N 57443N9644TFloyd Andrew W · Mesa, AZBuilt 1960 · S/N 57444N9645XCall The Ball Aviation LLC · Phoenix, AZS/N 21057945N9646XKomko Randy M · Mckenna, WABuilt 1962 · S/N 21057946N9648XWilt Michael J · Windham, NHBuilt 1962 · S/N 21057948N9650XJorsey Elizabeth A · Reidsville, NCBuilt 1962 · S/N 21057950N9653XSchuman Karl A · Fort Worth, TXBuilt 1962 · S/N 21057953N9661TSiebe James E · Moscow, IDBuilt 1960 · S/N 57461N9661XMangan Communications Inc · Bastrop, TXS/N 21057961N9662XMacdonald Kaitlyn A · Dillon, MTS/N 21057962N9664TKalebaugh Todd C · Lostine, ORBuilt 1960 · S/N 57464N9665TFlight Tech Inc · Arlington, WAS/N 57465N9665XBarclay Richard W · Elbert, COBuilt 1962 · S/N 21057965N9667XBoschee Gary L · North Fort Myers, FLBuilt 1962 · S/N 21057967N9668TSevier Brady · Ronan, MTBuilt 1960 · S/N 57468N9672XPallister John S · Battle Ground, WABuilt 1962 · S/N 21057972N9675XKenai Gravel Products LLC · Galena, AKBuilt 1962 · S/N 21057975N9676XMoore Samuel B · Tucson, AZBuilt 1962 · S/N 21057976N9679XMurphree David A · Lake Saint Louis, MOBuilt 1963 · S/N 21057979N967AEKreil Curtis L · White City, ORBuilt 1962 · S/N 21057978N9681XCentral Aviation LLC · White City, ORS/N 21057981N9683TFroes Carlos D · Avondale, AZBuilt 1960 · S/N 57483N9683XBates Roger · Palm Beach Gardens, FLBuilt 1962 · S/N 21057983N9684TKobe Thomas J · Lake Placid, FLBuilt 1960 · S/N 57484N9685TBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 57485N9686XMclenaghan Alvin N · Phoenix, AZBuilt 1962 · S/N 21057966N9687TPractical Software Solutions Inc · Windsor, COBuilt 1960 · S/N 57487N9688XDrm Aviation LLC · Glencoe, ALBuilt 1962 · S/N 21057988N9689TSutphen Clinton M · Saint Hedwig, TXBuilt 1960 · S/N 57489N9692THarbaugh Eric M · Russell, KSS/N 57492N9694TGarza Gilberto · Yuma, AZS/N 57494N9694XDawson Timothy E · Dahlonega, GAS/N 21057994N9695XHam Robert · El Cajon, CABuilt 1962 · S/N 21057995N9696TJ & F Aviation Adventure LLC · North Fort Myers, FLBuilt 1960 · S/N 57496N9699TBas Part Sales LLC · Greeley, COS/N 57499N9702XPilot Mountain Aviation LLC · Pilot Mountain, NCBuilt 1962 · S/N 21058002N9703XSalsa De Tomate Inc · Craig, COS/N 21058003N9706XEl Paso Aero Inc · El Paso, TXBuilt 1962 · S/N 21058006N9714XEtheredge William T IV · Texas City, TXBuilt 1962 · S/N 21058014N9716XLowe Joshua T · Mount Baldy, CAS/N 21058016N9717XEichner David K · Portland, ORBuilt 1962 · S/N 21058017N9718XLooney Jeffrey J · New Boston, TXBuilt 1962 · S/N 21058018N9720NNash Clay S · Irving, TXS/N 57036N9720XHogue Richard L · Dos Palos, CABuilt 1962 · S/N 21058020N9722XEddy David A · Gilroy, CABuilt 1962 · S/N 21058022N9723XThornton James P · Amesbury, MABuilt 1962 · S/N 21058023N9725XNewling Galen J · Bremerton, WABuilt 1962 · S/N 21058025N9730XHaase Herman · Stockton, CABuilt 1962 · S/N 21058030
Back to AD 76-14-07 R2