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.

N540MDPlane Fun Inc Tr Trustee · Snellville, GABuilt 2008 · S/N 0043N540MGLevin Robert A · Elkins Park, PABuilt 1990 · S/N 004N540MMJohnson Barry · Roanoke, ALBuilt 1990 · S/N 3122N540MPDukes Jeff A · Cape Coral, FLBuilt 1999 · S/N 37N540MRGrinstead Holdings LLC · Cincinnati, OHBuilt 2007 · S/N 40157N540MXSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2008 · S/N 8N540NDAerosim Academy Inc · Sanford, FLBuilt 2010 · S/N 172S10984N540NEAirswiss Inc · Wilmington, DEBuilt 1984 · S/N 402C0809N540PSOlerud Erik · Dulles, VABuilt 2002 · S/N RI-02N540PULeo S Anton · Aliso Viejo, CABuilt 2003 · S/N 2844096N540RLache Benjamin Isaac · Port Orange, FLBuilt 1995 · S/N 1101N540RBEhrich Kevin J · New Braunfels, TXBuilt 1989 · S/N 001N540RCHuffstutler Stephen C · Uvalde, TXBuilt 2002 · S/N 2014N540RFRussell William L · Washington, INBuilt 2010 · S/N 20566N540RMMokry Robert B · San Francisco, CABuilt 2001 · S/N 12N540RROrr David A C · Lake Forest, CABuilt 2018 · S/N 048N540RSLee Ric A · Sandy, UTBuilt 2013 · S/N 049N540SBAusbrooks Benjamin P · Meridian, MSBuilt 1999 · S/N 52361N540SCMorton Michael E · Hickory, NCBuilt 1950 · S/N 139N540SESoar International LLC · Olive Branch, MSBuilt 2001 · S/N 28N540SGBurns Melissa · Talkeetna, AKBuilt 2005 · S/N 0035N540SSCode Supplies Inc · Rossville, TNBuilt 2011 · S/N 006N540SWSolberg Scott E · Comfort, TXBuilt 2022 · S/N 74515N540TAMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2003 · S/N 2017N540TCRoss Shannon M · Boise, IDS/N 3043N540TDFitzgerald Craig A · Collinsville, OKS/N 059N540TMRegistered aircraftBuilt 1991 · S/N 3163N540TR222 Aviation LLC · Oakhurst, CABuilt 2004 · S/N 111N540TXBoho LLC · Lewes, DEBuilt 1979 · S/N 1005N540UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020164N540VLLuker Victor R Jr · Terrell, TXBuilt 2000 · S/N 3224N540WSOlerud Erik · Dulles, VABuilt 2002 · S/N 0032N540WTTurner Mark D · Roseville, CABuilt 2026 · S/N 001N540WWWischer Neil O · Davenport, WABuilt 2014 · S/N 001N540XCampbell Scott A · Marseilles, ILBuilt 2011 · S/N 001N540XSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2008 · S/N 2N540XXRegistration Pending · Kingman, AZRegistration pendingBuilt 2008 · S/N 6N54100Pilot Aeromedical Consulting Services LLC · Freeland, MIS/N 32-7300040N54102Adriatic Holdings LLC · Cheyenne, WYBuilt 1981 · S/N 17274875N54105Gopub Aviation Inc Trustee · Wilmington, DEBuilt 2004 · S/N 1139N54107Duininck James R · Willmar, MNBuilt 1976 · S/N 18-7709020N54108Lawson Troy · Kettle Falls, WABuilt 1981 · S/N 17274877N5410BOklahoma Soaring Association · Mustang, OKBuilt 1956 · S/N 33410N5410HMeggers Roger D · Baker, MTBuilt 1949 · S/N 18-1N5410UN5410u LLC · West Babylon, NYBuilt 1967 · S/N D-8531N5410YFoxtrot Air LLC · Highmore, SDBuilt 1964 · S/N 18-8176N54115Mang Aero Club Inc · Belleville, MIBuilt 1981 · S/N 17274879N5411AMarc Aircraft Holding LLC · Soldotna, AKBuilt 1979 · S/N 21063422N5411BBailey Carl D · Huntington, WVBuilt 1956 · S/N 33411N5411DFellows David O · Mc Alpin, FLS/N D-4903
Back to AD 2007-04-19 R1