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.

N5221TPalmer Charles S · Hernando, MSBuilt 1976 · S/N TC-1995N5221WGrady John M · Perham, MNBuilt 1961 · S/N 28-258N5221XVandegrift Robert W · Waynesboro, VABuilt 1969 · S/N 200N52220Meyer Jeffrey K · Osceola, WIBuilt 1980 · S/N 17274444N52225Robinett Douglas · Laguna Niguel, CABuilt 1973 · S/N 18262466N52226Kettell Merrilee · Eureka, MTBuilt 1973 · S/N 18262467N5222DRegistration Pending · Muncie, INRegistration pendingBuilt 1979 · S/N 17272456N5222ESmith Nathan C · Kenai, AKBuilt 1959 · S/N 50522N5222JFlywyo LLC · Kalispell, MTBuilt 1980 · S/N 17273738N5222PGharazeddine Raja N · Kaplan, LABuilt 1958 · S/N 24-249N5222RLebeouf Bros Towing LLC · Bourg, LABuilt 1976 · S/N 18503021N52232Mustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10870N5223AGeneral Plumbing Inc · Walnut Creek, CABuilt 1979 · S/N 21063316N5223MGraham Holdings Inc · Atherton, CANon-citizen corporation, flight hours not reportedBuilt 2002 · S/N 20608180N5223RN5223r LLC · Opa Locka, FLBuilt 1974 · S/N 17263437N5223TBarnard Kevin D · Columbia Station, OHBuilt 1972 · S/N 28-7225362N5223WStover Jeffrey Wayne · Gastonia, NCBuilt 1961 · S/N 28-260N52241Christiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10879N52245Poursartip Nader · Hayward, CABuilt 1975 · S/N 164-75N52248Flight School Of Gwinnett · Lawrenceville, GABuilt 1981 · S/N 17274458N5224DMoreland Aviation Enterprises Inc · Byron, ILBuilt 1957 · S/N 50122N5224EFlight Training Aircraft LLC · Wilmington, DEBuilt 2008 · S/N 172S10875N5224GBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 172S9144N5224KAri Ben Aviator Inc · Fort Pierce, FLBuilt 1980 · S/N 17274018N5224LWight John M · Merrimack, NHBuilt 1967 · S/N 28-4518N5224NCasper James R · Decorah, IABuilt 1980 · S/N 18267581N5224TPerkins Barber Shop · Jennings, LABuilt 1972 · S/N 28-7205248N5224UNeil Anthony Foster Holdings LLC · Santa Rosa, CABuilt 1964 · S/N 206-0224N52250Lowcountry Flight LLC · Johns Island, SCBuilt 1980 · S/N 17274460N52251Sims Robert M · Mc Ewen, TNBuilt 1973 · S/N 18262485N52252Bos John D · Locust Grove, GABuilt 1980 · S/N 17274461N52253Blue Viking Enterprises LLC · San Jose, CABuilt 1973 · S/N 18262487N52255Springville Flying Club · Spanish Fork, UTBuilt 1973 · S/N 18262488N52256Hutchinson Scott N · Broadlands, VAS/N 18262489N5225DMustang Sally Aviation LLC · Camden, SCBuilt 1979 · S/N 17272457N5225ERowland Taylor · Wasilla, AKBuilt 1959 · S/N 50525N5225LFirst Aero LLC · Edmonds, WABuilt 2002 · S/N 18281151N5225NBartlett Joseph L · Eugene, ORBuilt 1980 · S/N 18267582N5225REnright Darren · Lakeville, MNBuilt 2002 · S/N 18281152N5225THolt Joseph · Farmington, MOBuilt 1972 · S/N 28R-7235199N5225UMagic World Ky LLC · Sulphur, KYS/N 172RG0289N5225VKuhn Chad · Boulder, WYBuilt 1975 · S/N 21060867N5225WAll The Way Up Aviation LLC · Valrico, FLBuilt 1962 · S/N 28-262N52261Christiansen Aviation LLC · Wilmington, DEBuilt 1980 · S/N 17274465N52262Skymates Inc · Wilmington, DES/N 172S9412N52267Olds Forge Flyers Inc · Lansing, MIBuilt 1980 · S/N 17274471N5226DFargo Jet Center LLC · Fargo, NDBuilt 2008 · S/N 172S10880N5226JMcgreen John R · Albany, NYBuilt 1980 · S/N 17273740N5226LVancura Aviation LLC · Seffner, FLBuilt 1967 · S/N 28-4520N5226MTrader Robert D · Madison, INBuilt 1978 · S/N M-2014
Back to AD 2007-04-19 R1