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.

N5165MAl & Zal Corp · Gaylord, MIBuilt 2002 · S/N 17281092N5165RAvocado Air LLC · Perkasie, PABuilt 1974 · S/N 17263382N5165SVerte Chad W · Centralia, WABuilt 1970 · S/N 28-7105019N5165ULytle Mark J · Grand Rapids, MIBuilt 1994 · S/N DM0126N5165WMetro Flyers LLC · Jackson, MSBuilt 1961 · S/N 28-196N51665Rotor-Lift LLC · Swartz Creek, MIS/N 404N5166EHanson Michael M · Kent, WABuilt 1959 · S/N 50466N5166LEvans Jeffry · League City, TXBuilt 1967 · S/N 28-4451N5166RCrown Flying Club · Overland Park, KSBuilt 1974 · S/N 17263383N5166XRegistered aircraftBuilt 1969 · S/N 185N51670Colorado Northwestern Community College · Rangely, COBuilt 1980 · S/N 17274336N51675Crawford Aviation Services LLC · Flagstaff, AZBuilt 1968 · S/N 18-8571N5167EJkg LLC · Murfreesboro, TNBuilt 1978 · S/N 17271747N5167GWyatt Colby · Cherokee, OKBuilt 1951 · S/N 22302N5167HBest Joseph J · Coldwater, MIBuilt 1975 · S/N 17265357N5167KMulhall Timothy Patrick · Lampasas, TXBuilt 1950 · S/N NAV-4-2067DN5167MTuggle Casey · Chattanooga, TNS/N M-2043N5167PSoutheast Airways LLC · Gainesville, GABuilt 1958 · S/N 24-184N5167SAngel Carl L · Pikeville, TNBuilt 1970 · S/N 28-7105021N5167WThomas Bobby W Sr · Benson, NCBuilt 1961 · S/N 28-198N51687Ambron Trevor L · Valdosta, GABuilt 1978 · S/N AA5B-0857N5168ATurning Final LLC · Granby, COBuilt 1979 · S/N 21063294N5168GForster Edward J · Antrim, NHBuilt 1950 · S/N 21186N5168HBenallo Joseph D · Homer, AKBuilt 1948 · S/N 14-179N5168NRidgley Kirk L · Shingle Springs, CABuilt 1980 · S/N 18267555N5168PCreegan John T Jr · Dundee, ILBuilt 1958 · S/N 24-185N5168TVrooman Lawrence M · Winterville, NCBuilt 1967 · S/N 12N5168WRegistration Pending · Etowah, TNRegistration pendingBuilt 1961 · S/N 28-199N51693Borreson Anthony · Reno, NVBuilt 1977 · S/N 411N51699Styer David B · Pendleton, ORBuilt 1977 · S/N 416N5169DHomesick Angel LLC · Black Hawk, COBuilt 1958 · S/N 51269N5169EVenbro Holdings LLC · Brooklyn, NYBuilt 2002 · S/N 172S9038N5169GPepper Tyler I · Port Orange, FLBuilt 1951 · S/N 22760N5169JPotter Kent W · Laurel, MTBuilt 1976 · S/N 340A0004N5169LBishop Andre · Greenback, TNBuilt 1967 · S/N 28-4455N5169MEngdahl Thomas L · Rohnert Park, CABuilt 1978 · S/N MC-584N5169PStockdale Alexander Ian · Los Banos, CAS/N 24-187N5169SGoddard Julius W Jr · Perry, GABuilt 1970 · S/N 28-7105023N5169VMalcolm Douglas · Shell Beach, CABuilt 1980 · S/N 172RG0458N516AC39 Victor Aviation Inc · Macomb, ILBuilt 2000 · S/N 1294-2000N516AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2021 · S/N 28020045N516AVN388v LLC · Manassas, VABuilt 1981 · S/N 17275205N516BYIberlin James M · Gillette, WYBuilt 1992 · S/N 788N516CACharlie Alpha Flying Club · Sunnyvale, CABuilt 1978 · S/N 18266702N516CR516 Ontario Capital Holdings LLC · Hartland, WIBuilt 2005 · S/N 1309N516CSMccullough Construction Inc · South Jordan, UTBuilt 1998 · S/N 17280428N516DDFawcett Walter L Jr · Wolfeboro, NHBuilt 1981 · S/N 18-8109010N516DMSmall Howard · West Hartford, CTS/N 18280028N516EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12867N516EVAerofly Procurement LLC · Owasso, OKBuilt 2005 · S/N 1445
Back to AD 2007-04-19 R1