OpenAirDocs.org
AD 71-24-04

Registered aircraft · 1,525

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

N10007Insko Matthew T · Papillion, NEBuilt 1966 · S/N 21058839N100DZSkydive Santa Barbara LLC · Lompoc, CABuilt 1966 · S/N U206-0693N100LDPenning Jeffrey D · Clear Lake, IABuilt 1968 · S/N 17700990N102BMeyjes Gijsbert Posthumus · Cadillac, MIS/N 337-0024N102JJGrose Christopher E · San Antonio, TXBuilt 1966 · S/N T210-0123N104AFNance David B · Quinton, VABuilt 1967 · S/N 17700238N108CCFlaugher Jonathan S · Poquoson, VABuilt 1965 · S/N 3370202N10ARK Airmotive LLC · St Helens, ORBuilt 1966 · S/N U206-0738N10CCSmith Kord S · Salmon, IDBuilt 1964 · S/N 206-0166N10GMAlo Aviation LLC · Titusville, FLS/N T210-0151N10RVKoehn Shane Michael · Scooba, MSBuilt 1964 · S/N 21058418N110SMPenhall Michael Joseph · Lake Forest, CABuilt 1964 · S/N 337-0023N111NJNew Jersey Forest Fire Service · Trenton, NJBuilt 1964 · S/N U206-0278N111PWKilgore Eric M · Genoa, NVS/N T210-0066N117MMMelton Charlie W · Grand Saline, TXBuilt 1968 · S/N 17700872N11LATwo-Ten LLC · Ramona, CABuilt 1968 · S/N 21059058N121ECN121ecfllyers LLC · South Jordan, UTBuilt 1967 · S/N 17700036N122FSiver Creek Capital LLC · Emery, SDS/N 21058967N123JTGraham Richard A · Wichita Falls, TXBuilt 1965 · S/N T210-0019N123UAwg Aviation LLC · Ainsworth, IABuilt 1968 · S/N 21059004N1269RThompson Steve E · Port Angeles, WABuilt 1968 · S/N 17700625N137MCPoland Gilbert Guardian · Dothan, ALBuilt 1965 · S/N 337-0127N13BJSevcik Clint · Medford, MNS/N 21058486N13EFMcgough Julie Eileen · Red Oak, TXBuilt 1967 · S/N 337-0794N1414CSorby Steven R · Lyman, WABuilt 1966 · S/N 337-0419N141JGCardinal 1jg LLC · Bakersfield, CABuilt 1968 · S/N 17700930N143JBKing John · Torrance, CABuilt 1965 · S/N 337-0102N146FCUsda Forest Service Fepp · Malvern, ARBuilt 1966 · S/N P206-0247N147MLPatton Andrew Joseph · Andrews, INBuilt 1968 · S/N 17701000N14872Blumenthal James R · Kingman, AZBuilt 1973 · S/N U20602144N1505TN1505t LLC · Tucson, AZBuilt 1966 · S/N P206-0212N1545GSaltzer Eric R · Somerton, AZBuilt 1966 · S/N T210-0208N169FLBlue Moon Holding Co LLC · Boca Raton, FLS/N 17700047N169JWPatterson Matthew D · Knoxville, TNBuilt 1968 · S/N 17700360N16HTAviation Specialties Unlimited Inc · Boise, IDBuilt 1964 · S/N 2060134N1708ZVr Jet LLC · Goshen, INBuilt 1963 · S/N 336-0008N1717XSay Plastics Inc · Jacksonville, TXBuilt 1967 · S/N T2100267N1724THanna David B · Tonasket, WABuilt 1964 · S/N 21058360N1725ZDavid B Curliss · Beavercreek, OHBuilt 1963 · S/N 336-0025N1730ZLoftis Kenneth L · Phoenix, AZBuilt 1963 · S/N 336-0030N173MCCiochetti Michael J Jr · Clayton, GABuilt 1968 · S/N 21058960N1746ZThompson Nathan G · San Antonio, TXS/N 336-0046N1768ZMoskowitz Craig B · Sheffield, MABuilt 1963 · S/N 336-0068N1773ZMcclay David H · Lagrande, ORBuilt 1963 · S/N 336-0073N1779ZLewis Lionel · Tacoma, WABuilt 1963 · S/N 336-0079N177ASManning Bryan E · Northport, ALBuilt 1968 · S/N 17700967N177CCHoel Martin J · Waterloo, IABuilt 1967 · S/N 17700654N177CVZinkel Gregory S · Leander, TXS/N 17700640N177DKKeen David S · Amherst, NHBuilt 1967 · S/N 17700567N177EBDodd Lisa · Sandpoint, IDBuilt 1967 · S/N 17700562
Back to AD 71-24-04