AD 2007-04-19 R1

Registered aircraft · 108,434

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

N3131ZPralle Jeffory K · Wasilla, AKBuilt 1959 · S/N 22-7076N3132CBlack Eric · Fort Jones, CABuilt 1978 · S/N R18200238N3132FN3132f LLC · Metairie, LABuilt 1973 · S/N 32-7440023N3132PSarratt Curtis H · Annapolis, MDBuilt 1957 · S/N 23-1056N3132TUballe Ruben · Axtell, TXBuilt 1967 · S/N 17700432N3132WSteve Rodemer Esq LLC · Colorado Springs, COBuilt 1973 · S/N CE-477N3132YLampkin George G · Forney, TXBuilt 1962 · S/N 18254132N3133PLumley John J · Delray Beach, FLFirst renewal noticeBuilt 1957 · S/N 23-1057N3133QLearn 2 Fly Ct LLC · Simsbury, CTBuilt 1977 · S/N 28-7716138N3133RSprott James D · Harrison, ARBuilt 1967 · S/N 18258533N3133SMitchell Terry R · Tallahassee, FLBuilt 1964 · S/N 18255633N3133TGiddy Up Aviation LLC · Ada, OKBuilt 1967 · S/N 17700433N3134DHanson Parry B · Eagle Creek, ORBuilt 1955 · S/N 31932N3134LTrax Eric E · Vero Beach, FLBuilt 1965 · S/N 310J0134N3134PSchmidt Casey D · Cedar Rapids, IAS/N 23-1059N3134UBaine Larry A · Marne, MIBuilt 1962 · S/N 18254534N3134WDans Flying Service Inc · Crookston, MNS/N 19027CN3135CVeech Shawn M · Big Lake, AKBuilt 1954 · S/N 30934N3135DSkycavu Inc · Hi Rls Mtn Pk, NMNon-citizen corporation, flight hours not reportedBuilt 1955 · S/N 31933N3135EHerring Christopher E · Granbury, TXBuilt 1978 · S/N 17271447N3135GDrake Michael L · Bellevue, WABuilt 1995 · S/N 20513N3135LTempelhof Aviation · Las Vegas, NVBuilt 1965 · S/N 310J0135N3135QGrf Aviation LLC · Destin, FLBuilt 1967 · S/N 18258135N3135RSerna Alvaro V · San Antonio, TXBuilt 1969 · S/N 28R-31117N3135ULogue Christopher A · Trout Run, PABuilt 1962 · S/N 18254535N3135WFlycarolina LLC · Concord, NCBuilt 1973 · S/N D-9538N31368Anderson Aviation Inc · Anderson, SCBuilt 1955 · S/N 140755N3136CPark Avenue Group Inc · Stuart, FLBuilt 1954 · S/N 30935N3136FMurdock Lloyd W · Princeton, KYBuilt 1966 · S/N 18257236N3136QN3136q Flyers LLC · Las Vegas, NVBuilt 1967 · S/N 18258136N3136RKuntz Trucking Co · Gridley, ILBuilt 1967 · S/N 18258536N3136SSeiler Richard D · Bozeman, MTBuilt 1964 · S/N 18255636N3136XBobbett Robert Todd · West Richland, WABuilt 1998 · S/N EA-620N3136YReed Jason B · Faith, SDBuilt 1962 · S/N 18254136N3136ZSchafer Patrick A · Marietta, OHBuilt 1959 · S/N 22-7080N31377Piercy Brian A · Kalispell, MTBuilt 1978 · S/N 32-7840126N3137CKlausler Thomas W · Lakeville, MNBuilt 1954 · S/N 30936N3137ERegistered aircraftBuilt 1978 · S/N 17271448N3137FJbm Endeavors LLC · Chewalah, WABuilt 1966 · S/N 18257237N3137RGriffith Moseley Johnson & Associates Inc · Port Arthur, TXBuilt 1968 · S/N 18258537N3137SManley Robert E · Ferndale, WABuilt 1964 · S/N 18255637N3137UCurson Randy J · Cape Coral, FLBuilt 1962 · S/N 18254537N3137YLopez Juan F Jr · Del Rio, TXBuilt 1962 · S/N 18254137N31380Aldred John B · Washoe Valley, NVBuilt 1978 · S/N 32-7840127N31385Registration Pending · Missoula, MTRegistration pendingBuilt 1978 · S/N 28-7816554N31388Sisk Farms LLC · Hopkinsville, KYBuilt 1978 · S/N 32-7840128N3138CTurbo-Sphere Inc · Longmont, COBuilt 1978 · S/N R18200239N3138QShepard Donald · Lake Havasu City, AZBuilt 1967 · S/N 18258138N3138R15 Rides LLC · Manteo, NCBuilt 1967 · S/N 18258538N3138TJones Daniel D · Ekron, KYBuilt 1968 · S/N 17700438
Back to AD 2007-04-19 R1