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.

N508FGRidgeline Assets LLC · Wilmington, DEBuilt 2022 · S/N 172S12910N508GLCirone James · Pampa, TXBuilt 1974 · S/N 0508N508HSBlue Chase LLC · Wilmington, DEBuilt 2013 · S/N 13462N508NDCorsair Aviation LLC · Pacoima, CABuilt 2010 · S/N 172S11061N508RFFugate Richard Dee · Rochester, MNBuilt 1981 · S/N 28-8190281N508SDPate Charles C Trustee · Wichita, KSBuilt 1979 · S/N 18503980N508TCFisher Travis L · Odessa, TXBuilt 1982 · S/N 21064741N508THFowler David P · Freeport, MEBuilt 1967 · S/N 28-22869N508VStahl Victor A · Houston, TXBuilt 2006 · S/N 71303N508XCHirst Jeremy · Solana Beach, CABuilt 2016 · S/N CC19-0005N50901United Indian Missions Inc DBA · Tucson, AZBuilt 1973 · S/N U20601951N50906Aitken & Wilson Aviation LLC · Leesburg, VABuilt 1980 · S/N 17274232N5090EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271705N5090MAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-34N5090RStahla Russell A · Girdwood, AKBuilt 1976 · S/N 18503005N5090SSturm Neal M · Randolph, NJBuilt 1971 · S/N 28R-7135091N5090TWoodcox Edmund A · West Monroe, NYBuilt 1968 · S/N MB-346N5090UVolatile Aero Ventures LLC · Boulder City, NVS/N 206-0090N5090WJaybird Aviation LLC · San Antonio, TXBuilt 1961 · S/N 28-99N5091717 Leasing LLC · Englewood, COBuilt 1980 · S/N 17274233N5091CMartin Steven J · Phoenix, AZBuilt 1982 · S/N T30300132N5091DKuhn Chad · Boulder, WYBuilt 1958 · S/N 51191N5091EAmerican Asset Leasing LLC · Aurora, ORBuilt 1978 · S/N 17271706N5091PSpicuzza Robert A · Waterford, MIBuilt 1958 · S/N 24-100N5091SLancellotti Peter · Knoxville, TNBuilt 1980 · S/N R18201503N5091TBlank Philip J · Pleasanton, CABuilt 1981 · S/N R18201814N5091VWilliams Timothy J · Fernandina Beach, FLBuilt 1975 · S/N 21060833N5091WRegistration Pending · Anchorage, AKRegistration pendingBuilt 1961 · S/N 28-100N50924Robinson Mark V · Vacaville, CAS/N 318N50926Registered aircraftBuilt 1992 · S/N 002N5092EKaye Russell G · New Fairfield, CTBuilt 1978 · S/N 17271707N5092MZavalney Steven Michael · Canyon, TXBuilt 1978 · S/N MB-891N5092NMill-Run LLC · Lewes, DES/N D-9893N5092TZigo Daniel N · Madill, OKBuilt 1968 · S/N MB-347N50935Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 17274365N50937Tls Aviation LLC · Eldridge, IABuilt 1973 · S/N U20601953N50939Heart X Aviation LLC · Salmon, IDBuilt 1973 · S/N U20601954N5093EBohmer Carla M · Tulsa, OKS/N 17271708N5093FRedick Albert L II · Reno, NVBuilt 2006 · S/N 80900N5093KL A M Capital Management LLC · Sheridan, WYBuilt 1980 · S/N 17273964N5093PAir Chutney LLC · Waynesboro, VABuilt 1958 · S/N 24-102N5093RSkyhawks Inc · Montoursville, PABuilt 1974 · S/N 17263331N5093SPerez Matthew C · Indianapolis, INS/N 28-7125301N5093TTaylor Allen S · Oak Harbor, WABuilt 1968 · S/N MB-378N50941Labrucherie Peter E · El Centro, CAS/N 17264216N50944Munoz Jacqueline T · Huntsville, ALS/N 17264217N50947Bend Aircraft Mechanics LLC · Bend, ORBuilt 1974 · S/N 17264218N5094RHigh View Air LLC · Driftwood, TXBuilt 1974 · S/N 17263332N5094SBoraam Aviation Inc · Prospect Heights, ILBuilt 1971 · S/N 28R-7135094N5094TKrass Roman · West Hills, CAS/N M-1137
Back to AD 2007-04-19 R1