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.

N4477RDyer George C · Victor, MTBuilt 1976 · S/N 18502967N4477SMaynard J Smith Mobile Homes & Rvs Ltd · Okoboji, IABuilt 1975 · S/N E-699N44780Imler Jarrod M · Gallatin, TNBuilt 1975 · S/N 28-7510005N44782Alsup Jonathan S · Tok, AKBuilt 1974 · S/N 32-7500002N44786Flight Academy LLC · Van Nuys, CAS/N 28-7515032N44789Dzialo Matthew J · Pawtucket, RIBuilt 1974 · S/N 28-7505011N4478AOrth Henry J · Wasilla, AKBuilt 1956 · S/N 18-4835N4478JFly 500 LLC · Fort Pierce, FLBuilt 1967 · S/N 28-22894N4478SLichter Robert L · Waban, MABuilt 1975 · S/N E-690N4478TSchroder David A · Venice, FLBuilt 1972 · S/N 28-7205168N4478XWhite Raymond W · Montrose, MIBuilt 1975 · S/N 28-7615017N44790Spence William M · Naples, FLBuilt 1974 · S/N 28R-7535007N44792Ocean Air Inc · Eugene, ORBuilt 1974 · S/N 28-7515064N4479RUp And Up Aviation LLC · Magnolia, TXS/N 17263221N4479SN4479s LLC · Nashville, TNBuilt 1975 · S/N D-9790N4479TSouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1972 · S/N 28R-7235033N4479YKnutson Wayne R · Tioga, NDBuilt 1966 · S/N 25-4108N4479ZHardan Weston W · Palmer, AKBuilt 1969 · S/N 18-8834N447BAHc01 LLC · Vero Beach, FLBuilt 2013 · S/N 2263N447BBFerree William M · Stafford Springs, CTBuilt 2017 · S/N 71509N447BDRegistration Pending · Columbia, KYRegistration pendingBuilt 2009 · S/N 60103N447BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 4496581N447BLBlue Line Aviation LLC · Smithfield, NCBuilt 2025 · S/N 4496606N447BRCordogan Clark & Associates Inc · Aurora, ILBuilt 1995 · S/N E-2991N447CFBleecker Lee M · Dousman, WIBuilt 1995 · S/N 0218N447CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282353N447DD115 Holdings LLC · Mansura, LABuilt 2025 · S/N 14929N447ERSilver Express DBA · Miami, FLS/N 172S10221N447GHorn Rodney L · Friendswood, TXBuilt 2008 · S/N 72825N447HHartz Paul · Lake Suzy, FLBuilt 2002 · S/N 169N447JCConner Jeff · Findlay, OHBuilt 2026 · S/N 41739N447JLKjolsing Jerome M · Camino, CABuilt 1966 · S/N TE-121N447KSPoletto Danny A · Great Falls, MTBuilt 1969 · S/N 28-25439N447MAState Of Montana · Helena, MTBuilt 1975 · S/N E-697N447MHKelsey Terry D · Guthrie, TXFirst renewal noticeBuilt 2006 · S/N 11193N447MKNorth Star Aviation Inc · Mankato, MNBuilt 2019 · S/N 4496459N447NASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N CJ-130N447PJones Thomas C · Friendswood, TXS/N 108N447PAPollux Aviation Ltd · Wasilla, AKBuilt 2006 · S/N 11197N447PWCannon David A · Magnolia, TXBuilt 2013 · S/N 13454N447RCEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1995 · S/N 0205N447RMRocky Mountain College · Billings, MTBuilt 2024 · S/N 28020197N447TCOrange Sky LLC · Naples, FLS/N 006N447VMiller Dustin · Visalia, CABuilt 2016 · S/N 40447N447WLM5-210c LLC · Castle Pines, COBuilt 1967 · S/N 18258588N447WPWall Cameron J · Enid, OKBuilt 2002 · S/N 5701N44800Schoppe Marc · Durham, NCBuilt 1975 · S/N 28-7505012N44802Page Aviation Services LLC · Fort Myers, FLS/N 28R-7535009N44805Gage Christopher · Truckee, CABuilt 1974 · S/N 28-7525008N44806Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1974 · S/N 28-7515037
Back to AD 2007-04-19 R1