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.

N3668CN3668c L L C · Depauw, INBuilt 1954 · S/N 31167N3668DLkj Holdings LLC · Amarillo, TXS/N EA-92N3668KPiston Aviation LLC · Saint Charles, MOBuilt 1967 · S/N 28-23678N3668QPaul B Meadowbrook Pc · Albany, ORFirst renewal noticeS/N MA-255N3668URedmond John L · Santa Clarita, CABuilt 1980 · S/N E-1701N3668ZYork Matthew J · Waterloo, ILS/N 22-7566N3669Grasso Vaughn L · Oak Hill, FLBuilt 1970 · S/N JPH-2N3669NMcdonald Douglas E · Deering, NDBuilt 1947 · S/N 12-1920N3669QMarshall Jerry W · Centennial, COBuilt 1967 · S/N MA-256N3669RFulks Helicopter Service LLC · Norfolk, NEBuilt 1970 · S/N 28-5772N3669WDocken Marvin O · Omaha, NEBuilt 1966 · S/N 32-578N366CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 1369N366CTAia Charlie LLC · Henderson, NVBuilt 2025 · S/N 172S13341N366DHummer Family Capital Aviation LLC · Boonton, NJBuilt 1966 · S/N 310K0230N366DMSwaggart Paul Blake · Touchet, WABuilt 2005 · S/N 1625N366GCHavens Aviation LLC · Blacklick, OHBuilt 2000 · S/N S1809N366HPRey Del Cielo LLC · San Antonio, TXBuilt 1974 · S/N E-632N366KWhite Thomas J · Agua Dulce, CABuilt 1957 · S/N 34529N366KBThomas William K · Live Oak, FLBuilt 1986 · S/N 586N366KJBaker Victor R · Carson City, NVBuilt 2015 · S/N BAK002N366MATew Services Corp · Wilmington, DEBuilt 1999 · S/N 18280596N366MDN366md LLC · Salinas, CABuilt 1974 · S/N 20-0015N366METhree Six Six Mike Echo LLC · Mantua, UTBuilt 2000 · S/N 18280856N366MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881689N366NHState Of New Hampshire Dept Of Safety · Concord, NHBuilt 2008 · S/N 18282106N366PSkyway Unlimited Inc · New London, NCBuilt 1997 · S/N E-3099N366PAPureflight Aviation Training LLC · Newberg, ORBuilt 2020 · S/N 1264N366PSA-Team Family LLC · Ashland, ORBuilt 1974 · S/N TE-971N366PWEuroaviation Inc Trustee · KematenBuilt 1992 · S/N EA-530N366RAdema Walker · Enid, OKBuilt 2007 · S/N 23100N366SGibbs John M · Monterey, CABuilt 1960 · S/N CD-243N366STN366st LLC · Kenesaw, GABuilt 2025 · S/N 172S13331N366TBLouie Co Pilot LLC · Liberty Lake, WAS/N 1724N366XRomano Stephen Henry Daniel · Seattle, WABuilt 1976 · S/N 7005CN366ZMendel Carl · Port Charlotte, FLBuilt 1975 · S/N E-769N36700Archuleta Jeffrey Michael · Abilene, TXBuilt 1978 · S/N 28-7890526N3670EFresh-Pic Harvest Inc · La Quinta, CABuilt 1980 · S/N TK-124N3670NMcmanigle Jeffrey M · Osakis, MNBuilt 1946 · S/N 12-1921N3670RPecht Brian J · Lewistown, PABuilt 1969 · S/N 28-5773N3670UHoffman Kevin · Chatsworth, GABuilt 1980 · S/N TC-2332N3670XDoerhoff Daniel L Trustee · Lone Jack, MOBuilt 1969 · S/N 317N3670YRoussin David G · Newville, ALBuilt 1963 · S/N 21058170N3670ZFaught Jeffrey R · Bismarck, NDBuilt 1960 · S/N 22-7408N36711N36711 Piper LLC · Provo, UTS/N 28-7890527N3671CCharlie Aviation LLC · Philpot, KYBuilt 1978 · S/N R18200302N3671FHenson Ronald E · Bonita Springs, FLS/N EA-94N3671MFigvam LLC · New York, NYBuilt 1980 · S/N E-1705N3671RRoberts Charlie E · Cleveland, GABuilt 1969 · S/N 28-5774N3671WOdean Steve · Palmer, AKS/N 32-580N36724Reeves Richard G · La Verne, CABuilt 1980 · S/N TC-2333
Back to AD 2007-04-19 R1