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.

N545SFCrabtree William D · Big Lake, AKBuilt 2026 · S/N 001N545SMWood Kyle Aubrey · Soldotna, AKBuilt 1999 · S/N 545N545TYoung Trinity D · Mena, ARS/N D-6599N545UCatching Freedom LLC · Bozeman, MTS/N 172S12311N545VSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N D-6321N545WKenmore Crew Leasing Inc Trustee · Bellingham, WAS/N 21060656N545WAStine Scott A · Vincennes, INBuilt 1968 · S/N 28R-30577N545WHBledsoe Bobby H · Hot Springs, ARBuilt 2000 · S/N 32-46156N545WRCumulus Aviation Services LLC · Port Orange, FLBuilt 1972 · S/N 28R-7235119N545WWGrisham Michael H · Paulden, AZBuilt 1955 · S/N 22-3320N545YCatching Freedom LLC · Bozeman, MTS/N 172S12327N545ZDornoch Services LLC · Dover, DEBuilt 2008 · S/N 172S10770N5460NWylie David · Sharon Springs, NYBuilt 1968 · S/N 28-3800N5460PT & C R Wing'N It LLC · Tempe, AZBuilt 1958 · S/N 24-517N5460UMall Eugene R · Cairo, NYBuilt 1967 · S/N CE-173N5461Lb Flying Aces LLC · Wilmington, DEBuilt 1991 · S/N E-2621N5461AYaeger Edwin R · Stoneville, NCBuilt 1958 · S/N 35661N5461DCenter For Endodontics Inc · Fresno, CABuilt 1957 · S/N D-4966N5461JGlyn Dwr Aviation LLC · Kalispell, MTS/N 310R0259N5461KFaragallah Allan A · Garden Grove, CABuilt 1980 · S/N 17274127N5461LClinton Lance D · Lago Vista, TXBuilt 1974 · S/N AA5-0511N5461PGraham Truett A · Lubbock, TXBuilt 1958 · S/N 24-518N5461RRegistered aircraftBuilt 1998 · S/N 35N5461SCarter Kenneth M Jr · Castle Rock, COBuilt 1980 · S/N R18201577N5461WGarvey David G · Erie, PAS/N 28-541N5461XState Of Alaska · Anchorage, AKBuilt 1980 · S/N U20605775N54626Continental Title Trust LLC Trustee · Wichita, KSBuilt 1970 · S/N 18260199N54628Ohio State University · Columbus, OHBuilt 1981 · S/N 17275013N5462LGilbert Jason J · Oakland, MEBuilt 1973 · S/N AA5-0362N5462QLeading Edge Flight Academy LLC · Bend, ORBuilt 1973 · S/N 17261792N5462THebert David · Lafayette, LABuilt 1982 · S/N R18201874N5462XThomas Jackson Smitih · Baton Rouge, LABuilt 1977 · S/N E-1105N54633Warner Walter M · Willow, AKBuilt 1981 · S/N 17275016N54634Savannah Airplane Venture LLC · Myrtle Beach, SCBuilt 1981 · S/N 17275017N54635Memphis Navy Flying Club · Millington, TNBuilt 1981 · S/N 17275018N5463DBlanco Austin · Newcastle, CABuilt 1957 · S/N D-4959N5463JMachado Joe L · Tucson, AZBuilt 1980 · S/N 17273804N5463KRick Aviation Inc · Newport News, VABuilt 1980 · S/N 17274129N5463LMcpherson Allen G · Batesville, INBuilt 2013 · S/N 82049N5463NM Sipolt Air LLC · Paradise Valley, AZBuilt 1980 · S/N 18267734N5463WAngels Envy Aviation LLC · Denison, TXBuilt 1962 · S/N 28-543N5464Larson Margaret June · Shelbyville, TNS/N 1006N54646Jordao Isabella C · Oklaunion, TXBuilt 1981 · S/N 17275022N5464DJprg Aviation Inc · Orlando, FLBuilt 1979 · S/N 17272576N5464KTrend Vector Aviation International Inc · Barrigada, GUBuilt 1980 · S/N 17274130N5464LKelly Michael J · American Fork, UTFirst renewal noticeS/N AA5-0364N5464VLivingood Richard A · Tucson, AZS/N 21060955N5465DPatten Sarah F · Catlett, VABuilt 1957 · S/N D-4976N5465KMonroe Pilots Association LLC · Monroe, NCBuilt 1980 · S/N 17274131N5465NRing Niel W · Buhl, IDBuilt 1980 · S/N 18267736
Back to AD 2007-04-19 R1