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.

N9570XGroves Chandler H DBA · Farmington, CAS/N 21057870N9571XBarnett David Kirk · Brock, TXS/N 21057871N9572XSparks James D · Glennallen, AKBuilt 1962 · S/N 21057872N9573TLearn To Fly LLC · Portal, GABuilt 1959 · S/N 57373N9574TMcclellan Fred L · Flint, MIBuilt 1960 · S/N 57374N9574XFlying Nova LLC · Anchorage, AKS/N 21057874N9576TDe Vincenzo Chiara · Chicago, ILBuilt 1960 · S/N 57376N9578XTvat LLC · Sun City, AZS/N 21057878N9580XNewman Michael Mcdermott II · Campo, CABuilt 1962 · S/N 21057880N9584TBruce Nicholson · Gallup, NMBuilt 1960 · S/N 57384N9586TRegistration Pending · Talent, ORRegistration pendingS/N 57386N9586XMclenaghan Alvin N · Phoenix, AZBuilt 1962 · S/N 21057886N9587XFulminare Aviation LLC · Ocala, FLBuilt 1962 · S/N 21057887N9588XHanson Roger D · Seattle, WABuilt 1962 · S/N 21057888N9589XFishel Thomas N Trustee · Reno, NVBuilt 1962 · S/N 21057889N9591XSparrow William L · Pike Road, ALBuilt 1962 · S/N 21057891N9592XLewis Carroll G Jr · Waxahachie, TXS/N 21057892N9593TDenny Charles A · Wilmington, OHBuilt 1960 · S/N 57393N9593XWhite Andrew W · Silverdale, WAS/N 21057893N9594TCooper Ventures LLC · Wesley, ARBuilt 1960 · S/N 57394N9596TBrockie Robert Huntley · Bozeman, MTS/N 57396N9596XStulken Merrill · Curtis, WABuilt 1962 · S/N 21057896N9597TMgm Home Service Inc · Atascadero, CAS/N 57397N9597XDavidson Ronald A · Pueblo West, COS/N 21057897N9598XOdell Eugene S · Yakima, WABuilt 1962 · S/N 21057898N9599TAviation Partners LLC · Highlands Ranch, COBuilt 1960 · S/N 57399N95PYJayviation Inc · Lake City, FLBuilt 1964 · S/N 21058514N9601XCervantes Jose M · San Diego, CAS/N 21057901N9602XMorehouse Darrell L · Glasgow, MTBuilt 1962 · S/N 21057902N9603XTerry Nickolas B · Maize, KSBuilt 1962 · S/N 21057903N9604TKay Bennie L · Brigham City, UTBuilt 1961 · S/N 57404N9605XTony Flies Inc · Sparta, NCBuilt 1962 · S/N 21057905N9606XRowland Douglas · Wichita, KSS/N 21057906N9607XBaldridge Steven J · Edmonds, WAS/N 21057907N9608XEsdaile Philip J · Woodland, CABuilt 1962 · S/N 21057908N9610TMulkey Randall L · Wellston, OKBuilt 1960 · S/N 57410N9610XSutton George E · Fullerton, CABuilt 1961 · S/N 21057910N9611XWinston Air LLC · Haleyville, ALS/N 21057911N9613TMilleman Barry M · Monticello, INBuilt 1960 · S/N 57413N9614TLucas Lester L · Napa, CABuilt 1960 · S/N 57414N9614XMountain Air Flying LLC · Brigham City, UTBuilt 1962 · S/N 21057914N9616XJim Barrett Photography Inc · Honolulu, HIBuilt 1961 · S/N 21057916N9621TJ D Kraemer Enterprises LLC · Fargo, NDS/N 57421N9626XPortman Joe · Elmendorf, TXBuilt 1962 · S/N 21057926N9627XW J Bolton Farms LLC · Marked Tree, ARBuilt 1962 · S/N 21057927N9629TBramlett Russell · Winder, GABuilt 1960 · S/N 57429N9630TBridgford Bruce H · Anaheim, CABuilt 1960 · S/N 57430N9634XScoggin Gerald William III · Port Saint Lucie, FLBuilt 1962 · S/N 21057934N9637XCypress Peak LLC · Pickens, MSBuilt 1962 · S/N 21057937N9639XFerguson John · Montrose, COS/N 21057939
Back to AD 76-14-07 R2