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.

N4818DBald Eagle Flying Club · South Portland, MEBuilt 1979 · S/N 17272367N4818LFischer Denise L · Lake View Terrace, CABuilt 1967 · S/N 28-4158N4819GVeer Aviation Tx LLC · Houston, TXBuilt 1979 · S/N 17273367N4819JDoran Jeffrey T · Westerville, OHS/N CD-1060N4819NSilva Robert · Davis, CABuilt 1979 · S/N 18267391N4819QPuryear Rodney K · Pampa, TXBuilt 1976 · S/N 18802556TN4819TJacob Rolando V · Las Vegas, NVBuilt 1972 · S/N 28-7205201N481AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843747N481ACVogel Lawrence O · Gig Harbor, WAS/N 1289-2000N481CPBlue Water Aviation LLC · Oakman, ALBuilt 2008 · S/N 18282048N481DGrey Goose LLC · Wasilla, AKBuilt 1957 · S/N 50255N481DMEdgewood Capital LLC · Joplin, MOBuilt 2001 · S/N 1307-2001N481EMClark Jeffrey V · Libertyville, ILBuilt 1996 · S/N 375-96N481EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12250N481GSSchmidt Grant S · Jamestown, NDBuilt 1973 · S/N 28-7325622N481HWilliams Stephen C · Georgetown, MEBuilt 1961 · S/N 185-0116N481JCollins Jason · Mansfield, OHBuilt 1977 · S/N 21061580N481JLWolfco Timber Services LLC · Lebanon, ORBuilt 2017 · S/N JA1607094N481MASlavens Timothy W · Howard City, MIBuilt 2003 · S/N 441-2003N481PMoody Bible Institute Of Chicago · Spokane Valley, WABuilt 1977 · S/N U20603684N481SAerogracia LLC · Heritage Ranch, CABuilt 1970 · S/N D-9094N481TN481t LLC · Pensacola, FLBuilt 1961 · S/N CD-310N481TRBowen Tim S · Robstown, TXBuilt 1978 · S/N U20604383N481WSBoer John W · Okeechobee, FLBuilt 2013 · S/N 71940N481XCMarino Jerry C II · San Francisco, CABuilt 2012 · S/N 111N48205Popinko Charles D · Obrien, FLBuilt 1977 · S/N DEC-2N4820DBledsoe Duane C · Glendale, AZBuilt 1979 · S/N 17272369N4820EHogan Mark C · Sisters, ORBuilt 1979 · S/N 18503880N4820FS&S Aviation Plus LLC · Greenville, ILBuilt 1976 · S/N 28-7790062N4820GAckerman Garry · Plano, TXBuilt 1979 · S/N 17273368N4820LFick Paul R · Deansboro, NYBuilt 1967 · S/N 28-4160N4820SCalico Construction Inc · Kensington, MDBuilt 1979 · S/N R18201432N4821AMeyer James D · Cheney, KSBuilt 1956 · S/N 22-3974N4821FOestreich Klaus M · Needville, TXBuilt 1976 · S/N 28-7790063N4821LFlying Rocks LLC · Sparkill, NYBuilt 1967 · S/N 28-4162N4821S4821s LLC · Ponte Vedra Beach, FLBuilt 1969 · S/N 32-1252N4821USouth Side Corp · Loomis, NEBuilt 1963 · S/N 205-0521N4822ALybarger Michael L · Hot Springs, ARBuilt 1956 · S/N 22-3975N4822DRegistered aircraftBuilt 1958 · S/N 34922N4822GHighpoint Strategies LLC · Cypress, TXBuilt 1979 · S/N 17273370N4822LMonaco Francis Achille · Martinez, GABuilt 1967 · S/N 28-4164N4822NBalinski Stephen W · Lusby, MDBuilt 1979 · S/N 18267394N4822SHolladay Pamela J · Louisville, KYBuilt 1969 · S/N 32-1253N4822VCantrell David R · Albany, GABuilt 1968 · S/N 30092N4823FEden'S Marine LLC · Jensen Beach, FLBuilt 1976 · S/N 28R-7635437N4823JHaunstein Manfred · Weirsdale, FLBuilt 1966 · S/N D-8337N4823PWilliams Charles S · Pearland, TXS/N 27-389N4823TCrane Kenneth J · Clinton, INBuilt 1972 · S/N 32-7200025N4823VStratus Air LLC · New Orleans, LAFirst renewal noticeBuilt 1980 · S/N 172RG0391N4824FWheeler Michael P · Declo, IDBuilt 1966 · S/N U206-0524
Back to AD 2007-04-19 R1