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.

N3971YLimestone County Sheriff Dept · Athens, ALBuilt 1964 · S/N 21058471N3976YKnutson Wayne R · Thompson, NDS/N 210-58476N3979YMontana Adventures Holdings LLC · Rainbow City, ALS/N 21058479N3983YMalpass William H DBA · Shreveport, LAS/N 21058483N3989YSchmitt Rudy · Brookshire, TXBuilt 1964 · S/N 21058489N3994YCrosco LLC · Canton, OHBuilt 1964 · S/N 21058494N400HXTevis David James · Colorado Springs, COBuilt 1964 · S/N 21058352N404BNCienski Todd A · Duncanville, TXBuilt 1965 · S/N 21058705N408GHMcdowell Kevin A · Tumwater, WABuilt 1959 · S/N 57075N418DKKnies Aviation Inc · Huntsville, ALBuilt 1964 · S/N 21058435N422BWBravo Whiskey LLC · Gilbert, AZBuilt 1968 · S/N 21059100N4321XGrady Auctions & Realty Inc · Newport, ARBuilt 1965 · S/N 21058623N4449GHuntley John · Bellingham, WABuilt 1962 · S/N 21058087N450DHHewitt Rod · Federal Way, WAS/N 21057998N455EDTurner James Glenn · Naples, FLBuilt 1962 · S/N 21058118N4567FPatterson Roland O · Semmes, ALBuilt 1960 · S/N 57314N4568CYorde Roger C · North Fort Myers, FLBuilt 1963 · S/N 21058142N456DHWilliams Metal And Machinery LLC · Irvington, ALS/N 21058042N45AMThornburg Rocky R · White Hall, ARBuilt 1964 · S/N 21058475N45VCHoyos Luis F · Fort Pierce, FLBuilt 1964 · S/N 21058282N467DHLopez Floyd W · Arroyo Seco, NMBuilt 1960 · S/N 57142N4702WFour Flying Fools LLC · Geneva, FLS/N 57532N4729WMichael J Kraynick Pllc · Hailey, IDBuilt 1965 · S/N 21058621N48PMFreeman Robert G DBA · Baker, FLBuilt 1960 · S/N 57567N4902UWallace Randall · Stamps, ARBuilt 1965 · S/N 21058602N4904UMcdonald Patrick B · Brownwood, TXBuilt 1965 · S/N 21058604N4905UPerformance Ag Indiana · Frankfort, INS/N 21058605N4909UGarner Howard E · Bonifay, FLBuilt 1965 · S/N 21058609N4910UN4910u LLC · Cushing, OKBuilt 1965 · S/N 21058610N4913UGarvey F Patrick · Churubusco, INBuilt 1965 · S/N 21058613N4914UCaldwell Gregg P · Desert Hot Springs, CABuilt 1965 · S/N 21058614N4924UScheren Raymond D · Johnson, VTBuilt 1965 · S/N 21058624N4927UBetz Brett A · Reminderville, OHBuilt 1965 · S/N 21058627N4934USatriana Robert L · Belen, NMBuilt 1965 · S/N 21058634N4942UCenturion LLC · Bonney Lake, WABuilt 1965 · S/N 21058642N4948URegistered aircraftBuilt 1965 · S/N 21058648N4960UHopkins Breck G · North Little Rock, ARBuilt 1965 · S/N 21058660N4963UAllen Shanda · Aynor, SCBuilt 1965 · S/N 21058663N4968UGreen Brandon K · Eufaula, ALBuilt 1965 · S/N 21058668N4969UTallgrass Aviation LLC · Sharon Springs, KSBuilt 1965 · S/N 21058669N4973UFlightpath Leasing LLC · Tallahassee, FLBuilt 1965 · S/N 21058673N4976UMoro Jim · Naples, FLS/N 21058676N4977UBaker Bryan D · Anderson, CABuilt 1965 · S/N 21058677N4992UReynolds Tracy L · Midlothian, TXS/N 21058692N4998USixty Five Two Ten LLC · Oak Island, NCBuilt 1965 · S/N 21058698N4BEMehrer Kelly · Apex, NCBuilt 1960 · S/N 57332N4CGAffordable Avionics Ind DBA · Chino, CABuilt 1965 · S/N T210-0033N506YZR&R Gray Equipment & Cattle LLC · Enid, OKS/N 21059139N5200QBas Part Sales LLC · Greeley, COBuilt 1969 · S/N 21059130N522LNomura Christopher · Riverside, CABuilt 1960 · S/N 57516
Back to AD 76-14-07 R2