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.

N5745PMiller Aaron T · New Braunfels, TXS/N 24-819N5746PYinyan Tech US Inc · Brea, CANon-citizen corporation, flight hours not reportedBuilt 1959 · S/N 24-820N5748PBaxter Randall T · Maple, NCBuilt 1959 · S/N 24-823N5750PRoberts Donald W · Flower Mound, TXBuilt 1959 · S/N 24-825N5751PKrager Aviation LLC · Perry, UTBuilt 1959 · S/N 24-826N5758PBarr Michael J · Colorado Springs, COBuilt 1959 · S/N 24-834N5759PDemars Michael · California, MDBuilt 1959 · S/N 24-836N5760PLoughlin Robert J · Midland, TXBuilt 1959 · S/N 24-838N5765PWomack Calvin E · Lakeside, TXBuilt 1959 · S/N 24-843N5766PMid Pacific Aero Services LLC · Honolulu, HIS/N 24-844N5767PMcdowra Christopher L · Paris, TXS/N 24-845N5768PBrooks David Paul · Mantorville, MNBuilt 1959 · S/N 24-846N5771PWhisky Zulu Inc · Klamath Falls, ORBuilt 1959 · S/N 24-849N5772PKasakoff Lloyd Abraham · Houston, TXBuilt 1959 · S/N 24-850N5775PChelf James Michael · Cedar Park, TXBuilt 1959 · S/N 24-853N5778PHunton Hugh R II · Midlothian, TXBuilt 1959 · S/N 24-857N5779PLechner Kevin P · Wurtsboro, NYBuilt 1959 · S/N 24-858N577DPLustfeldt Gordon L · Normal, ILBuilt 1959 · S/N 24-848N5780PWall Scott · Franksville, WIBuilt 1959 · S/N 24-859N5782PPaviation LLC · Lewes, DEBuilt 1959 · S/N 24-861N5784PMiller Jeffery Allen · Menifee, CAS/N 24-863N5785PSmith Clyde R Jr · Lock Haven, PABuilt 1959 · S/N 24-864N5786PMckowan Sheila R · Chatsworth, CAS/N 24-865N5788Knot Speed Ltd · Wilmington, DEBuilt 1966 · S/N 24-4580N5789PNiche Pharmaceuticals LLC · Shorewood, MNBuilt 1959 · S/N 24-868N5792PLadet William D · Las Vegas, NVS/N 24-871N5798PCiotta Anton Albert · Wallingford, CTBuilt 1959 · S/N 24-878N5799PMorgan E Neal · San Diego, CABuilt 1959 · S/N 24-879N57AASouth Texas Weather Modification Association · Pleasanton, TXBuilt 1962 · S/N 24-3303N57DJPasserby Randal K · Mesa, AZS/N 30-1292N5800PCencula Christopher D · Roseville, CABuilt 1959 · S/N 24-880N5802PHass Morgan E · Lyons, ORBuilt 1959 · S/N 24-882N5804PWitt Aviation LLC · Naperville, ILBuilt 1959 · S/N 24-884N5805PGrace Family Fellowship Inc · Oklahoma City, OKBuilt 1959 · S/N 24-885N5807PRichter Dickinson Aviation LLC · Moultrie, GABuilt 1959 · S/N 24-887N5811PJpl Flyers LLC · Metairie, LABuilt 1959 · S/N 24-891N5822PJstream Lc · Sheridan, WYBuilt 1959 · S/N 24-903N5824PClaxton Fred E · La Habra, CABuilt 1959 · S/N 24-905N5825PRobles Carlos J · San Jose, CABuilt 1959 · S/N 24-906N5827PTwo Seven Papa LLC · Pueblo, COBuilt 1959 · S/N 24-908N5833PCochran Keith W · Long Beach, CAS/N 24-914N5835PLoya Francisco · Crestline, CAS/N 24-916N5836PShort Final LLC · Murfreesboro, TNBuilt 1959 · S/N 24-917N5837PGoodman Wayne A · Conway, SCBuilt 1959 · S/N 24-918N5838PHoughtling Marvin · Pasadena, TXBuilt 1959 · S/N 24-919N5842PFlyair Flight Academy LLC · Flint, TXBuilt 1959 · S/N 24-923N5844PKoniar Steven L · Newcastle, OKS/N 24-925N5845PGriffel Brandon T · Frederick, MDBuilt 1959 · S/N 24-926N5849PJinnis Flight Enterprises LLC · Montgomery, TXBuilt 1959 · S/N 24-930N5850PInto The Forest Equipment LLC · Placerville, CABuilt 1959 · S/N 24-932
Back to AD 77-13-21