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.

N335KHSerafini Transportation LLC · Ringwood, NJBuilt 1979 · S/N 335-0025N335MCLewis University · Romeoville, ILBuilt 2022 · S/N 172S12879N335MDHamstra Armen Nofer · Saratoga, CABuilt 1982 · S/N 32-8206036N335MECentral Iowa Aviation LLC · Ankeny, IABuilt 2000 · S/N 172S8466N335MKNorth Star Aviation Inc · Mankato, MNBuilt 2018 · S/N 2881090N335NMarple Scott D · Indianapolis, INBuilt 1964 · S/N D-7752N335PElvin Robert Brian · Grove, OKBuilt 1996 · S/N E-3005N335PABorek Thomas J · Homestead, FLBuilt 1979 · S/N 18-7909158N335PCOcow LLC · Jenks, OKBuilt 1980 · S/N 335-0053N335PDRogue Aviation LLC · Newport Beach, CABuilt 2005 · S/N 10611N335PGSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 1504N335PW335 Leasing LLC · Englewood, COS/N 335-0011N335RAirdocs LLC · Atlanta, GABuilt 2000 · S/N E-3335N335RLWeeks James S · Boynton Beach, FLBuilt 2002 · S/N 23254N335RSYould Eric P Trustee · Palmer, AKBuilt 1977 · S/N 17268562N335RVCroce Matthew A · Palo Alto, CABuilt 2008 · S/N 80335N335SFRamont Ronald G Jr Trustee · Modesto, CABuilt 1977 · S/N 21062413N335SMMf Property Management LLC · Hattiesburg, MSBuilt 1979 · S/N 3350020N335SPMaui Aviators LLC · Pukalani, HIBuilt 2003 · S/N 172S9495N335TBpu Enterprises LLC · Schuylkill Haven, PABuilt 2016 · S/N 2452N335TBJkh Enterprises LLC · Westfield, INBuilt 1987 · S/N CE1166N335TCSchnell Daniel · Sisters, ORBuilt 1966 · S/N D-8274N335TJYork Michael · Reston, VABuilt 1979 · S/N 335-0012N335VHolden Donald T · Cherokee, IABuilt 1980 · S/N D-10338N335VHPremier Helicopters LLC · Carson City, NVBuilt 1994 · S/N 2464N335ZCosse Harold C · Euless, TXBuilt 1960 · S/N D-6484N3360FLane Glen Allen Jr · Cocoa, FLBuilt 1966 · S/N 18257360N3360MStyer David · Pendleton, ORBuilt 1977 · S/N 28-7816339N3360RRoschi Nancy L · Stevensville, MTBuilt 1975 · S/N 18502874N3360SMohler Earl C · Bonita, CAS/N 21059160N3360UBailes Ernest J IV · Shepherd, TXBuilt 1963 · S/N 18254760N3360VJustis Jeff · Oxford, MSBuilt 2022 · S/N 42029N3360XCrail Aviation LLC · Colorado Springs, COBuilt 1966 · S/N 3373N3360YFoote Jerry O · Unadilla, NYFirst renewal noticeBuilt 1962 · S/N 18254360N3361BSmith Marcus H · Roxboro, NCS/N 22-2166N3361DDe Lint Marcus W · Cove, ORBuilt 1955 · S/N 32159N3361ROlson Bartlet · Merrimac, WIBuilt 1967 · S/N 18258661N3361TPew Aaron · Mesa, AZS/N 17700661N3361UKelleher Chuck W · Shelby, MTBuilt 1963 · S/N 18254761N3362FMunoz Mario · Scottsboro, ALBuilt 1966 · S/N 18257362N3362RLight Jeffrey D · Woodville, VABuilt 1967 · S/N 18258662N3362TMain Cynthia M · Richmond, TXFirst renewal noticeBuilt 1967 · S/N 17700662N3362UGilliland Mcclaflin Wayne D · Powell, WYBuilt 1963 · S/N 18254762N33631First Class Emergency Vehicles LLC · Monroe, NCBuilt 1975 · S/N 32-7500026N33636Murphy George E · Robinson, ILBuilt 1975 · S/N 28-7525213N3363DTodd Michael E · Yelm, WABuilt 1955 · S/N 32161N3363EMcfly LLC · Casper, WYBuilt 1978 · S/N 17271518N3363MGlatt David · Bonita Springs, FLBuilt 1947 · S/N 12-2219N3363PDubois Aviation Inc · Chino, CABuilt 1958 · S/N 23-1320N3363REagles Flight LLC · Grove, OKBuilt 1967 · S/N 18258663
Back to AD 2007-04-19 R1