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.

N3250YEonm182 LLC · El Paso, TXBuilt 1962 · S/N 18254250N3250ZLawrence Grant Heath · Saratoga Springs, UTS/N 22-7198N32514Summit Flight Academy LLC · Peculiar, MOS/N 28-7525075N32518Lahmann Jason L · Tripoli, IABuilt 1974 · S/N 28-7515174N32519Bachert Nicholas T · California, MDBuilt 2020 · S/N 41353N3251ABrews LLC · Homer, AKBuilt 2007 · S/N 23100CN3251DE S P Aviation LLC · Wilmington, DES/N 32049N3251FRegistered aircraftBuilt 1967 · S/N 670044N3251WCorporate Flight Mangement LLC · Dallas, TXBuilt 1995 · S/N EA-576N3251YCarlson Andrew J · Ashville, NYBuilt 1962 · S/N 18254251N3251ZCopper River Airmotive LLC · Copper Center, AKBuilt 1959 · S/N 22-7199N32521Proflite Of Alaska LLC · Fairbanks, AKS/N 28R-7535065N32524Barth Tom L · Manhattan, KSBuilt 1974 · S/N 28R-7535067N32525Willaford Gina T · Cape Coral, FLBuilt 1974 · S/N 28-7525078N32526Cannon Adam H · Purcell, OKS/N 28-7525079N3252DQuigg Aircraft LLC · Muskegon, MIBuilt 1955 · S/N 32050N3252FBubes Michael D · Cocoa, FLBuilt 1967 · S/N 670045N3252JBas Part Sales LLC · Greeley, COS/N E-3252N3252PGodbout Kevin P · South Hadley, MABuilt 1957 · S/N 23-1197N3252QArcher Inc · South Ozone Park, NYBuilt 1977 · S/N 28-7790446N3252REllis Eric Lee Trustee · Lincoln, CABuilt 1995 · S/N E-2952N3252SWhite Robert E · Woodlawn, TNBuilt 1964 · S/N 18255752N3252TFugfugosh Mahdi A · Castro Valley, CABuilt 1967 · S/N 17700552N32531Greenville Flight LLC · Greer, SCBuilt 1974 · S/N 28-7515177N32534Bh534 LLC · West Hartford, CTBuilt 1974 · S/N 28-7505069N32539Orosz Ryan · Santa Clara, CABuilt 1974 · S/N 28-7505050N3253SCobb Darrell V · Corsicana, TXBuilt 1964 · S/N 18255753N32540Registration Pending · Mocksville, NCRegistration pendingBuilt 1975 · S/N 28-7525081N32542Jordening Kim L · Fairbury, NEBuilt 1974 · S/N 28-7515181N32543Echo 7 Tango Aviation LLC · Pottsboro, TXBuilt 1974 · S/N 28-7515183N32544Swaz Aviation LLC · Mesa, AZBuilt 1974 · S/N 28-7505071N32548Pray Aviation Inc · Augusta, KSBuilt 1974 · S/N 28-7515182N3254GEdling Tyrell R · The Dalles, ORBuilt 1995 · S/N E-2954N3254SAllen John C · Austerlitz, NYBuilt 1964 · S/N 18255754N3254UWright Ronald J · Olympia, WABuilt 1963 · S/N 18254654N3254WKelley James · Mena, ARBuilt 1965 · S/N 32-76N32550Minto Daniel Warren · Wake Forest, NCBuilt 2018 · S/N 14136CN32551Gcbc LLC · Norman, OKBuilt 1974 · S/N 28-7505072N32552Garys Fork Auto Service LLC · Hydes, MDBuilt 1974 · S/N 28R-7535068N32553Lathan Stefan · Monrovia, INS/N 28-7510024N32556Mcguire Richard L · Valparaiso, INBuilt 1974 · S/N 28-7525083N32559Eagle Valley Aviation LLC · Howard, PABuilt 1974 · S/N 28-7515186N3255FThomas Clayton · Culleoka, TNBuilt 1967 · S/N 670048N3255GSmith Julian Scott · Arlington, TXS/N 24531N3255HAlba Leasing Services LLC · Scottsdale, AZBuilt 2007 · S/N 11686N3255WPridmore Joseph P · Columbus, MSBuilt 1965 · S/N 32-77N3255ZBabin Joseph J · Fairbanks, AKBuilt 1959 · S/N 22-7203N32560Burchell Wade C · Chalfont, PABuilt 1974 · S/N 28-7515187N32565Cb Aviation Inc · Ogden, UTS/N 28-7515188N32566Mob Aviation USA LLC · Auburndale, FLS/N 14137C
Back to AD 2007-04-19 R1