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.

N4557LSkytypers Inc DBA · Las Vegas, NVBuilt 1979 · S/N AA5B1231N4557NWestra Aviation LLC · Beaver Dam, WIBuilt 1978 · S/N 340A0547N4557RThomson James A · Boron, CABuilt 1965 · S/N 28-21298N4557SJustus Gary R · Evergreen, COBuilt 1979 · S/N AA5B1235N4557TWomack Associates LLC · Lancaster, KYBuilt 1972 · S/N 28-7225188N4557YPogany Stone C · Anchorage, AKBuilt 1971 · S/N 18-8938N4558BDe Ley Taylor · Yorba Linda, CABuilt 1955 · S/N 31457N4558ESmith Gregory W · Weirsdale, FLS/N AA5B1239N4558FN4558f LLC · Columbus, OHBuilt 1966 · S/N 185-1062N4558HTjr Inc · Bellevue, NEBuilt 1979 · S/N 24-0765N4558JDaprile Jonathan · Port Charlotte, FLBuilt 1968 · S/N 28R-30418N4558KRankin Gary L · Vancouver, WABuilt 1948 · S/N NAV-4-1558N4558PAviation Services Of Tn Inc · Dover, DEBuilt 1960 · S/N 27-64N4558RMorgan Chad A · Sarepta, LABuilt 1965 · S/N 28-21300N4559AKsm Aviation LLC · Kalispell, MTS/N AA5B1245N4559BSpencer Douglas L · Lexington, GABuilt 1979 · S/N AA5B1246N4559JBolduc Michael A · Strong, MEBuilt 1968 · S/N 28R-30419N4559LAirtime Aviation Inc · Tulsa, OKBuilt 1979 · S/N AA5B1247N4559MSky High Ventures LLC · Bartlett, TNS/N E-1235N4559RCavu Flight LLC · Simpsonville, SCS/N 28-21301N4559TLeek Aviation LLC · Wilmington, DEBuilt 1972 · S/N 28-7205185N4559XJlp Flying LLC · Clewiston, FLBuilt 1975 · S/N 28R-7635089N455ADMoghis Edgar C · Redwood City, CAS/N 316N455AFGlacier Bay Aviation LLC · Fayetteville, GABuilt 1968 · S/N 17701336N455AKBarr Scott A · Barrow, AKS/N 18260061N455BDArchco II LLC · Bloomfield, NEBuilt 2004 · S/N 1029N455BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010039N455BTMarshall Tristen · Spokane Valley, WABuilt 1964 · S/N TC741N455CDSanta Barbara Biplane Tours LLC · Santa Barbara, CABuilt 2004 · S/N 0907N455CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282196N455DSanders Tyler B · Yuma, AZBuilt 1989 · S/N CE-1408N455DCAviation Safety Training International LLC · Butte, MTBuilt 1968 · S/N CJ-13N455DDBailey Steven S · Ottawa, KSBuilt 1995 · S/N 21455N455EDTurner James Glenn · Naples, FLBuilt 1962 · S/N 21058118N455EPDove Aviation 455ep LLC · Stuart, FLBuilt 1998 · S/N 17280664N455ETLakes Aircraft Inc. · Maumee, OHBuilt 1975 · S/N 0711N455FLFisher Jeffrey D · Omaha, NEBuilt 1971 · S/N 28-7125250N455FPRobert Corio Inc · Johnston, RIS/N TE-549N455HFlying 20 Club Inc · Newtown, CTBuilt 2000 · S/N 28-43393N455HCBas Part Sales LLC · Greeley, COS/N TC-586N455HSSagnieres Hubert · Newport, VTBuilt 2001 · S/N 18281054N455JIsler Jerry L · Donalsonville, GABuilt 2007 · S/N 1070N455JRHinaa Hidaa LLC · Chino Valley, AZS/N EA-124N455KBrooks Donald W · Lumberton, NJBuilt 1967 · S/N D-8440N455LPhoenix East Aviation LLC · Daytona Beach, FLS/N 34-7450172N455LBBaker Air Service LLC · Hahira, GABuilt 1997 · S/N 80184N455MArnold Curtis L II · Corsicana, TXBuilt 1965 · S/N TC-975N455MKNorth Star Aviation · Mankato, MNBuilt 2024 · S/N 4496580N455NMMoore Daniel O · Fairfield, CAS/N 48N455PN455p LLC · Fulshear, TXBuilt 1999 · S/N E3276
Back to AD 2007-04-19 R1