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.

N5720KCrumpler Chad C · Wichita, KSBuilt 1964 · S/N D-7520N5720MSongbird Aviation Inc · Lawrenceville, GABuilt 1968 · S/N 310P0020N5720PPatterman Emil S · Fort Worth, TXS/N 24-794N5720UHone Jason B · Carnation, WAS/N 28-26520N5720WThird Step 2 LLC · Gilbert, AZBuilt 1963 · S/N 28-1231N5721MWood Michael D · Huntington Beach, CABuilt 1968 · S/N 310P0021N5721QRawski Aviation LLC · Kingwood, TXBuilt 1965 · S/N 764N5721WPrecise William C Jr · Philadelphia, PABuilt 1963 · S/N 28-1247N5722BVelasquez Benjamin · Anchorage, AKS/N 33722N5722FChrabasz Frank L · Arlington, TXBuilt 1968 · S/N 28-25023N5722KBranaman Timothy J · Monument, COBuilt 1964 · S/N TC-737N5722PCrazy 8 Aviation LLC · Ridgecrest, CABuilt 1959 · S/N 24-796N5722QMyers Shawn · Louisville, KYBuilt 1965 · S/N 3063N5722UPfeifer Eric P · Hill City, KSS/N 28-26524N5722VShank Joel F · Brawley, CABuilt 1966 · S/N CE-36N5723FOdyssia LLC · Corpus Christi, TXS/N 28-25024N5723JMcdonald Larry H · Little River, SCBuilt 1974 · S/N 18263498N5723WWells Chad · Draper, UTBuilt 1963 · S/N 28-1281N5724FKim Sungtae · Fort Worth, TXFirst renewal noticeBuilt 1968 · S/N 28-25025N5724JPurdue Aviation LLC · West Lafayette, INBuilt 1980 · S/N 17273827N5724VN5724v LLC · Kalispell, MTBuilt 1966 · S/N D-8103N57252Mooney Flyers LLC · Crystal Lake, ILBuilt 1984 · S/N 24-1433N57259Trantham Joey L · Panama City, FLBuilt 1984 · S/N 24-1435N5725PJason Waddell Pllc · Oklahoma City, OKBuilt 1959 · S/N 24-799N5725QBaughman Air Service Inc · Stockton, KSBuilt 1965 · S/N 721N5725VCrumly Chris P · Woodlake, CABuilt 1966 · S/N CE-40N57267Devine Robert · Albuquerque, NMBuilt 1984 · S/N 24-1436N5726BBend Aircraft Rentals LLC · Bend, ORBuilt 1956 · S/N 33726N5726KRegistered aircraftBuilt 1964 · S/N D-7571N5726QAllen Colin S · Leonardtown, MDBuilt 1965 · S/N 3065N5727EZeitvogel Jeanine · Gulf Shores, ALBuilt 1978 · S/N 17271928N5727FJones Brian W · Portland, ORBuilt 1968 · S/N 28-25028N5727NQualitair LLC · MicheistadtBuilt 1977 · S/N 18503320N5727VCulver Investments LLC · Gordon, TXBuilt 1966 · S/N D-8186N57280Conklin Michael L · Grand Blanc, MIBuilt 1984 · S/N 24-1438N57283Collins James L · Bradenton, FLBuilt 1984 · S/N 24-1439N5728BHawkins Charles A Sr · Chillicothe, OHBuilt 1956 · S/N 33728N5728PElite Aviation LLC · Grants Pass, ORBuilt 1959 · S/N 24-802N5728QKuss Luke A · Hutto, TXBuilt 1965 · S/N 3066N5728UPagratis Periklis · Savannah, GABuilt 1970 · S/N 28-26545N5728VGlenn Metalcraft Inc · Princeton, MNBuilt 1966 · S/N CE-25N5728WGregor Ally W · Orlando, FLBuilt 1963 · S/N 28-1331N57298Trent Daniel R Sr · Point Pleasant, WVBuilt 1973 · S/N 28R-7435074N5729DLanzara Anne M · Salem, VABuilt 1956 · S/N 22-4427N5729PSturt Michael H · Whitehouse, OHBuilt 1959 · S/N 24-803N5729UFredericks Robert T · Burnsville, MNBuilt 1969 · S/N 28-26546N572ABSchwab Craig A · Fort Walton Beach, FLS/N 572SFN572ATAtp Aircraft 3 LLC · Wilmington, DEBuilt 2005 · S/N 4496194N572BCT & D Ironhorse LLC · Tampa, FLBuilt 2022 · S/N 14557N572BPThomas Andy K · Cary, NCBuilt 1983 · S/N CE-1019
Back to AD 2007-04-19 R1