OpenAirDocs.org
AD 77-13-21

Registered aircraft · 3,193

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

N6097PGuest Aviation LLC · Crane Hill, ALBuilt 1959 · S/N 24-765N60CSAir Flight Enterprises Inc · South Daytona, FLBuilt 1958 · S/N 24405N60WFEngels John · Edmond, OKBuilt 1959 · S/N 24-1635N6101PLockett Terrell M Sr · Winter Haven, FLBuilt 1959 · S/N 24-1199N6102PAllen Darren Kerr · Thomasville, GABuilt 1959 · S/N 24-1200N6104PKimsey Thomas W · Warner Robins, GABuilt 1959 · S/N 24-1202N6106PRegistration Pending · Mesa, AZRegistration pendingBuilt 1959 · S/N 24-1204N6112PBurnett Jennifer · Palmer, AKS/N 24-1212N6114PCompton Mark E · Garfield, KYBuilt 1959 · S/N 24-1214N6118PNovak Mark S · Dawson, NEBuilt 1959 · S/N 24-1218N6119PModisette Jeremy W · Baldwin, GABuilt 1959 · S/N 24-1219N611VProtain Jaden · Reno, NVBuilt 1959 · S/N 24-968N6120PDremel Ronald W · North Bend, PABuilt 1959 · S/N 24-1220N6121PSmith Gloria M · New Hampton, NYBuilt 1959 · S/N 24-1221N6126PDallas Jets Group LLC · Canton, TXBuilt 1959 · S/N 24-1226N6130PHiga Bertram · Northridge, CAS/N 24-1230N6134PJ-Tom Inc · Lincoln, NEBuilt 1959 · S/N 24-1234N6136PPlane Fun Inc Tr Trustee · Snellville, GABuilt 1959 · S/N 24-1236N613FPlane Fun Inc Tr Trustee · Snellville, GABuilt 1970 · S/N 39-45N6140PBrake It LLC · Pensacola, FLBuilt 1959 · S/N 24-1241N6141PRs Agricultural Operations LLC · Dell City, TXS/N 24-1242N614JDCc Aviation Inc · Tracy, CABuilt 1967 · S/N 30-1517N614RSecker David · San Jose, CAFirst renewal noticeBuilt 1964 · S/N 30-658N6150PCobb Berrien · Smyrna, GABuilt 1959 · S/N 24-1251N6151PRoberson Michael B · Winterville, NCBuilt 1959 · S/N 24-1252N6154PLonhart Donald E · Greeley, COBuilt 1959 · S/N 24-1255N6155PSturm Steve G Trustee · Springdale, ARBuilt 1959 · S/N 24-1256N6157PFrazier Jon A · Vista, CABuilt 1959 · S/N 24-1258N6160PBbg Air Ventures LLC · Chandler, AZBuilt 1959 · S/N 24-1261N6162PKiester Michael E · Duncan, OKBuilt 1959 · S/N 24-1263N6163PCommache Avn Inc · Flint, MIBuilt 1960 · S/N 24-1264N6167PRico Nathaniel J · Astoria, ORBuilt 1959 · S/N 24-1268N6169PKlier John M · Alpine, CABuilt 1959 · S/N 24-1270N616SRBarendregt Melvin E · Heyburn, IDS/N 24-1800N6170PMaurer Bruce C · Power, MTBuilt 1959 · S/N 24-1271N6173PSwenson James A · Lake Point, UTBuilt 1959 · S/N 24-1274N6174PAbernathy Larry D · Vernon, TXBuilt 1959 · S/N 24-1275N6178PFolse Eldred J · North Las Vegas, NVBuilt 1959 · S/N 24-1280N617EDMente Charles · Homestead, FLBuilt 1968 · S/N 24-4765N6181PLowe David M · Sacramento, KYBuilt 1959 · S/N 24-1283N6184PCollins Michael J · Chandler, AZBuilt 1959 · S/N 24-1286N6187PFlowers Ricky B · Klamath Falls, ORBuilt 1959 · S/N 24-1289N6192PLevin Sidney M · Buffalo Grove, ILBuilt 1959 · S/N 24-1294N6194PCrosby Tire & Body Shop Inc · Crosby, NDBuilt 1959 · S/N 24-1296N61BBAeronautical Technical Service Inc · Collierville, TNS/N 30-875N61UComanche Skye LLC · Savannah, GABuilt 1966 · S/N 30-1004N6202PCollins Owen Stewart · Toccoa, GAS/N 24-1303N6203PClark Jason H · Ridgecrest, CABuilt 1959 · S/N 24-1304N62052Bolinger Ray G · Kuna, IDBuilt 1959 · S/N 24-1235N6205PTwo Dot Aircraft Ll · Kalispell, MTS/N 24-1307
Back to AD 77-13-21