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.

N4888ZFrancom Jeffery S · Malad City, IDS/N 22-8470N4889Albert Lea Arpt Inc · Albert Lea, MNBuilt 1969 · S/N 041N4889DPink Skies Inc · Willoughby, OHBuilt 1979 · S/N 17272387N4889GKittitas Aero Inc · Kittitas, WABuilt 1979 · S/N 17273436N4889JRegistered aircraftBuilt 1967 · S/N D-8424N4889LWerner Joseph H · Wauconda, ILBuilt 1967 · S/N 28-4255N4889STiger Wings LLC · Hoover, ALBuilt 1971 · S/N 32-7100013N4889TS&P Aviation LLC · Albuquerque, NMS/N 28-7205217N488ACAustin Peay State University · Clarksville, TNBuilt 2015 · S/N 13791N488BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881788N488CMEmery Kenneth Russell Jr · Odessa, FLBuilt 2011 · S/N 73322N488DDRegistered aircraftBuilt 1967 · S/N CE-143N488DJDelta Juliet Holco I LLC · Ocoee, FLBuilt 2025 · S/N 2881981N488DPRodarte Lionel · Downey, CABuilt 1974 · S/N E-522N488EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12256N488FDLittleton Darrell D · Atlanta, TXBuilt 1968 · S/N D-8700N488HPHigh Performance Aircraft LLC · El Cajon, CABuilt 1989 · S/N CE-1338N488JBSpitzer Helicopter LLC · Wilmington, DEBuilt 2012 · S/N 13379N488JFMentoraire LLC · Lake Forest, CABuilt 1953 · S/N G-298N488JWKagey David M · Seabrook, TXBuilt 1972 · S/N 17261113N488KCPterofranc Flight Services LLC · Redding, CABuilt 2006 · S/N 11383N488LGErnst Donald E · North Pole, AKBuilt 1975 · S/N 14175N488MAKing John R · San Rafael, CABuilt 1988 · S/N RB-01-4-88N488MTTisler Mark R · Bemidji, MNBuilt 2009 · S/N 81744N488PLutz Brian W · Russellville, ARBuilt 1965 · S/N 28-21081N488RDWhitnell Mark A · Lehigh Acres, FLBuilt 1966 · S/N 1300N488RHI F Rooks & Associates LLC · Memphis, TNBuilt 1982 · S/N U20606488N488RRMenke Rex A · Medical Lake, WABuilt 1972 · S/N 93N488SSale Reported · Friday Harbor, WASale reported, pending cancellationS/N 4140529N488SJDeans Casing Service Inc · Holdenville, OKFirst renewal noticeBuilt 1977 · S/N 414-0959N488SPSugarpop Air LLC · Chicago, ILBuilt 1967 · S/N 310N-0029N488TWilliams Alvis Leon · Heavener, OKS/N D-6726N488TCKoch Gregory S · Long Beach, MSS/N 465-74N488TWFreeman Jack C · Dumas, ARBuilt 2002 · S/N 4315N488UVUtah Valley University · Orem, UTBuilt 2018 · S/N 4496451N488XHahn Jesse J · Cedar Rapids, IAS/N 5111N489Snyder Ralph J · Colorado Springs, COBuilt 1993 · S/N 20003N4890FSkyline Sheet Metal Inc · Troutdale, ORBuilt 1966 · S/N U206-0590N4890PSale Reported · Willow, AKSale reportedBuilt 1961 · S/N 18-7762N4890QNew Frontier Aviation LLC · Fort Benton, MTBuilt 1976 · S/N 18802626TN4890RRebecca Lynn Flying Service Inc · Livingston, NYBuilt 1975 · S/N 18802408TN4890UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842235N4891BLiberty School Of Aviation Inc · Miami, FLRevoked, canceledBuilt 1955 · S/N 35191N4891EHerman Darrel K · Lebanon, ORS/N 18268281N4891JHarris Aircraft Leasing Co · Oklahoma City, OKBuilt 1979 · S/N 17273691N4891LToga LLC · Dayton, VABuilt 1967 · S/N 28-4258N4891TRoss Stephen C · Santa Fe, NMBuilt 1972 · S/N 28-7205219N4891ZRustair Inc · Anchorage, AKBuilt 1980 · S/N U20606044N4892TTwo Tango Aviation LLC · Plant City, FLBuilt 1972 · S/N 28R-7235132N4892VPonto Michael A · Edgewood, NMBuilt 1968 · S/N 30131
Back to AD 2007-04-19 R1