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.

N6199RSchutte Ernest C W · Abita Springs, LAS/N T210-0099N6394BPepitone David D · Santa Fe, NMS/N 57459N63WSCooks Saw Manufacturing LLC · Newton, ALBuilt 1964 · S/N 21058333N6501XFisher John P · Surprise, AZBuilt 1960 · S/N 57501N6506XBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 57506N6507XBailey Scott D · Ione, CABuilt 1960 · S/N 57507N6510XSteinbroner Daniel J · Lawton, OKBuilt 1960 · S/N 57510N6515XDauenhauer Steven M · Springtown, TXBuilt 1960 · S/N 57515N6519XN5746u LLC · Dover, DEBuilt 1960 · S/N 57519N6520XKenton Onstad · Parshall, NDBuilt 1960 · S/N 57520N6521XNelson Scott W · Summerset, SDBuilt 1960 · S/N 57521N6529XOvando Jorge · Sherman Oaks, CABuilt 1960 · S/N 57529N6531XSchwartz Alan M · Hurleyville, NYBuilt 1960 · S/N 57531N6538XRegistration Pending · Fallon, NVRegistration pendingBuilt 1960 · S/N 57538N6544XAnderson Joseph · Tillamook, ORBuilt 1960 · S/N 57544N6545XTail Chaser LLC · Wilmington, DEBuilt 1960 · S/N 57545N6548XGardner Maureice E · Garden City, KSS/N 57548N6550XButterfield Rory A · Milan, NMBuilt 1960 · S/N 57550N6555XViera Fernando Jr · Asbury, MOBuilt 1960 · S/N 57555N6557XYarnell Bruce W · Stockton, MOBuilt 1960 · S/N 57557N6576XG23 Holdings LLC · Hollywood, FLBuilt 1960 · S/N 21057576N6593XWondra J Paul · Newbury Park, CAS/N 21057593N6598XVolk Kenneth L · Waskom, TXS/N 21057598N65MPWard Gerald · Austin, TXS/N 21057904N6600XBlanton David L · Valley Center, KSBuilt 1960 · S/N 21057600N6608XJancaterino Daniel · Hull, MAS/N 21057608N6610XJason Bullard LLC · Star City, ARBuilt 1960 · S/N 21057610N6613XPeery Robert C · Burns, TNBuilt 1960 · S/N 21057613N6618XRoark Ken W · Cisco, TXS/N 21057618N6619XMartin Kevin · New Carlisle, OHBuilt 1960 · S/N 21057619N6625XBothell Eric L · Center, COS/N 21057625N6631XPelland John J · Antioch, ILBuilt 1961 · S/N 21057631N6635XNewsom Larry E Jr · Hernando, MSS/N 21057635N6636XAllen Leigh E · Bedford, WYBuilt 1961 · S/N 21057636N6638XSipple Paul K · Moorpark, CAS/N 21057638N6639XLee Michael A · Arlington, WABuilt 1960 · S/N 21057639N6644XCamous Daniel E · Miami, FLS/N 21057644N6645XHarrison Joshua C Trustee · Huntington Beach, CABuilt 1960 · S/N 21057645N6650XMccloskey Brett E · Bexley, OHBuilt 1960 · S/N 21057650N6654XDoss Foster T · Powell Butte, ORBuilt 1960 · S/N 21057654N6659XSchell Kerry · Arvada, COBuilt 1960 · S/N 21057659N6661XOzer Cenk · Sequim, WABuilt 1960 · S/N 21057661N6668XHocus Holdings LLC · Carrollton, OHBuilt 1961 · S/N 21057668N6677XMuhlenbrock Guillermo Rene Jr · Las Vegas, NVS/N 21057677N6678XKinman Kary Wade · Panama City Beach, FLBuilt 1961 · S/N 21057678N6682XDuff John W · Alligator, MSBuilt 1960 · S/N 21057682N6685XTaliaferro John P · Birmingham, ALBuilt 1961 · S/N 21057685N6687XReed Ted R · San Angelo, TXBuilt 1961 · S/N 21057687N6689XBravo Echo Echo LLC · Millersview, TXS/N 21057689N6690XWinston Marine LLC · Bellingham, WABuilt 1961 · S/N 21057690
Back to AD 76-14-07 R2