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.

N5255KReighley Robert G · Xenia, OHBuilt 1967 · S/N 18258124N5255MFlesher William Robert Jr · Gainesville, GABuilt 1978 · S/N M-2019N5255NLucas David · Lodi, OHBuilt 1980 · S/N 18267604N5255RZin Services LLC · Dover, DEBuilt 2009 · S/N 172S10987N5255SAkc III Aviation LLC · Port Saint Joe, FLS/N 24-1655N5255TGood Joseph A · Weymouth, MABuilt 1972 · S/N 28-7225375N5255UFlight Gear Aviation LLC · Pickerington, OHBuilt 1980 · S/N 172RG0304N5255WHoppes Curt · Saint Jacob, ILBuilt 1962 · S/N 28-299N52563Concord Flying Club Inc · Lafayette, CABuilt 1973 · S/N 18262677N52564Electrical Systems Professionals Inc · Trinidad, COBuilt 1973 · S/N 18262678N5256DTall Timber Flying Service LLC · Kalispell, MTBuilt 1979 · S/N 17272475N5256HHenley Robert J · Jeffersonville, INS/N 17265385N5256JKamenz Donald R · Mocksville, NCBuilt 1977 · S/N 340A0403N5256LIngram Aviation LLC · Johns Island, SCBuilt 1967 · S/N 28-4553N5256NGospel Ministries International · Collegedale, TNBuilt 1980 · S/N 18267605N5256SFargo Jet Center LLC · Fargo, NDBuilt 2009 · S/N 172S10901N52572Corrosion Savants LLC · Wilmington, DEBuilt 1973 · S/N 18262683N52577Hartman Edward L · N Canton, OHBuilt 1973 · S/N 18262684N5257ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2009 · S/N 18282181N5257EWings 4 Paws LLC · Yulee, FLBuilt 1983 · S/N 18268304N5257HWellman David H · Eugene, ORBuilt 1975 · S/N 17265386N5257NAmanda Air Inc · Talladega, ALBuilt 1980 · S/N 18267606N5257PAero Nautics Inc · Cheyenne, WYS/N 24-289N5257RTheodossiou Chris · Mandeville, LABuilt 1974 · S/N 17263471N5257SSchumaker Grant E · Wichita, KSBuilt 1980 · S/N R18201526N52587Mcconal Danny · Seminole, TXBuilt 1973 · S/N 18262690N5258ABeta Aviation L L C · Lewes, DEBuilt 1985 · S/N P21000841N5258NOffcourt Ltd · Del Mar, CABuilt 1980 · S/N 18267607N5258PMosley Hardy · Elko, NVBuilt 1958 · S/N 24-290N5258RZwiesler Thomas F · Ellington, CTBuilt 1974 · S/N 17263472N5258YChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9141N5258ZSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1981 · S/N 17275032N52590Aereo Flyers Inc · Camino, CABuilt 1973 · S/N 18262692N52593Mccarthy Justin P · Western Springs, ILBuilt 1980 · S/N 17274559N52595Cotton Christopher S · Dallas, TXBuilt 1973 · S/N 18262696N5259ECole Charles · Las Vegas, NVBuilt 1959 · S/N 50559N5259GSnowdog LLC · Litchfield Park, AZBuilt 1951 · S/N 22190N5259HTrifunovic Stefan · Grosse Pointe Park, MIBuilt 1975 · S/N 17265387N5259LPennsylvania Flying Assoc Inc · Saegertown, PABuilt 1967 · S/N 28-4557N5259PPacheco Carlos Antonio · Yuma, AZBuilt 1958 · S/N 24-293N5259RCarnathan Robert J · Newark, CABuilt 1974 · S/N 17263473N525AGNoland Ronald E · Weston, ORS/N 51986N525BECya Aviation LLC · Saint Marys, WVBuilt 2001 · S/N 0136N525BHWalker Craig · Pleasant View, TNBuilt 1982 · S/N D-10400N525CAWb Aviation LLC · Sugar Grove, ILBuilt 1981 · S/N E-1797N525CSPrivitt Bret J · Forest Hill, TXBuilt 1973 · S/N 270-73N525DVSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1987 · S/N 763N525FLSiebert Derrick R · Wausau, WIBuilt 1971 · S/N 28-7125357N525FSWrb Aircraft Leasing LLC · Wilmington, DEBuilt 2002 · S/N E-3445N525FWWall Freddy V · Raleigh, NCBuilt 1962 · S/N D-7044
Back to AD 2007-04-19 R1