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.

N5178HGage Scott M · Anchorage, AKS/N 14-200N5178JSeven Eight Juliet LLC · Edmond, OKS/N 340A0013N5178LMinick And Son LLC · Beatrice, NEBuilt 1967 · S/N 28-4464N5178RHampton Flying Services LLC · Portsmouth, NHBuilt 1974 · S/N 17263395N5178SG & M Aircraft Inc · Wheat Ridge, COBuilt 2002 · S/N 17281097N5178USoutheastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281098N5178WMahoney Christopher P · Quakertown, PABuilt 1961 · S/N 28-213N51790Tartock Russell L · Salisbury, NCBuilt 1979 · S/N AA5A-0850N51793Lindsey Richard A · Richmond, TXBuilt 1980 · S/N 17274347N5179DBlack Daniel L · Spicewood, TXBuilt 1958 · S/N 51279N5179GElie Jonathan · Hopewell Junction, NYS/N 22272N5179HFlight Time Builders Inc · Memphis, TNBuilt 1975 · S/N 17265362N5179PHangar 17 LLC · Sheridan, WYBuilt 1958 · S/N 24-199N5179UPower Flight LLC · Las Vegas, NVBuilt 1964 · S/N 206-0179N5179VFairmont State University · Fairmont, WVBuilt 1980 · S/N 172RG0460N5179XKor Reese W · Piedmont, SDBuilt 1969 · S/N 189N517APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843753N517AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2021 · S/N 28020046N517ATHodgson Christopher John · Santa Cruz, CABuilt 2017 · S/N 41237N517BWWomer Blaine A · Hemet, CABuilt 2007 · S/N 2843652N517CDPeker Lev M · Sylmar, CABuilt 2004 · S/N 1126N517DBBerry Bruce E · Louisville, TNBuilt 1977 · S/N 18266021N517DFForrest Michael D · Jasper, ALBuilt 1957 · S/N 24517N517DJUrquhart Dan DBA · Fallon, NVBuilt 1997 · S/N E-3075N517DLDelta Leema Aviation LLC · Moncks Corner, SCBuilt 1977 · S/N 17268965N517GSPtag Flight Service LLC · Vidalia, GABuilt 1996 · S/N 2996N517HHart James A · Arlington, VABuilt 2021 · S/N 42219N517JGollus Daniel T · Lockport, NYBuilt 1997 · S/N 22753N517JCProfessional Pilot Services · Appleton, WIBuilt 1971 · S/N 28-7125098N517JLSchmidt Robert G · Coppell, TXBuilt 1958 · S/N D-5762N517JPJones Jerry K · Syracuse, UTBuilt 2007 · S/N 001N517KBCorkins William J · Auburndale, FLBuilt 2025 · S/N 3300N517KGRegistration Pending · Pittsburg, TXRegistration pendingBuilt 1980 · S/N D10350N517KTAir-One Helicopters LLC · Lincoln Park, MIBuilt 2016 · S/N 13985N517LBuchenroth Steven L · Huntsville, OHFirst renewal noticeBuilt 1969 · S/N BP1N517MAKilo Charlie Aeronautics LLC · Baton Rouge, LABuilt 2017 · S/N 18283007N517MMMiller Jeremy M · Hazle Township, PABuilt 1978 · S/N 32R-7885191N517MPMorey Organization Inc · Wildwood, NJBuilt 2014 · S/N TH-2419N517MSJewett John G · Ellensburg, WABuilt 1978 · S/N R18200681N517PCAfrican Bible Colleges Inc · Karval, COBuilt 1973 · S/N 18261628N517PYYoung Millard Perrin · Raleigh, NCBuilt 1970 · S/N CE-305N517PZPapa Zulu LLC · Bend, ORBuilt 2004 · S/N 0931N517RBRbc Holdings LLC · San Juan, PRBuilt 2018 · S/N TH-2513N517RHRoyce Aviation LLC · Greenville, MSBuilt 1965 · S/N 310J0101N517RLAndrews Mimi M · Hilltop Lakes, TXBuilt 1996 · S/N 22626N517RSGraham Konner T · Pittsburg, TXBuilt 1998 · S/N 21117N517SAHalo For Freedom Warrior Foundation · Willow Park, TXBuilt 1966 · S/N U206-0644N517SCSpartan Education LLC · Tulsa, OKBuilt 2019 · S/N 2881264N517SHHelme Stanley B · Lodi, CABuilt 2003 · S/N 70624N517SMMcelvain Pete R · Iowa Park, TXBuilt 1968 · S/N 17257318
Back to AD 2007-04-19 R1