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.

N56AMPeavy Michael J · Chico, CABuilt 1976 · S/N 957N56BKoch & Koch Inc · Grass Valley, CABuilt 1994 · S/N TH-1730N56BEBirds Eye View Inc · Middletown, RIBuilt 2017 · S/N 2476N56BGGuernsey Gibson R · Belen, NMBuilt 1980 · S/N 140N56BPCeballos Oscar Felipe · San Ysidro, CABuilt 1978 · S/N P21000064N56BSHansen Nick K · Litchfield Park, AZBuilt 1987 · S/N 1N56BVEuroaviation Inc Trustee · KematenBuilt 1978 · S/N AA5A0719N56BWWnk Leasing LLC · Lewes, DEBuilt 1975 · S/N TC-1837N56CCMichel David L · Pickens, SCBuilt 1959 · S/N 24-1297N56CEWave Shack Acquisitions LLC · Lewes, DEBuilt 1991 · S/N LARES 0001N56CJSchmid Urs · Jupiter, FLBuilt 2010 · S/N 82781N56CKThurber Mark C · Manchester, MDBuilt 1962 · S/N 21058112N56CMFamily Practice Associates LLC · Ulysses, KSS/N 310R1422N56CPBulldog Aviation LLC · Goodyear, AZBuilt 1969 · S/N 700003N56CVVaughn Geoffrey · Brunswick, GABuilt 1976 · S/N 14017N56CWLaurel Aviation Inc · Decatur, ILBuilt 2024 · S/N 18283256N56DBBerger Dale · Bay Village, OHBuilt 2002 · S/N 1128N56DCAero Services Lc · Woods Cross, UTBuilt 1967 · S/N T210-0280N56DDMeier Perry S · Conroe, TXBuilt 1976 · S/N D2DN56DEWaypoint Aviation Corp · San Jose, CABuilt 2013 · S/N 70883N56DGEagle East Aviation Inc · North Andover, MABuilt 1976 · S/N 17266239N56DWReed John S · Wasilla, AKS/N 18-7709159N56EB56 Eb Inc · Jacksonville, FLBuilt 1968 · S/N 28R30647N56ECBpc Aviation LLC · Rosamond, CABuilt 1962 · S/N 17249661N56EEStansfield Tod A · Elm Grove, WIBuilt 1961 · S/N D-6703N56EKQuailair LLC Trustee · MichelstadtS/N 2890145N56EPSanders Flight Training Center Inc · Jasper, ALBuilt 1978 · S/N 17270728N56ERGsell Bruce Ward · Southampton, NJBuilt 1979 · S/N AA5B-1094N56FAir Kings LLC · West Chester, PABuilt 1975 · S/N 17265348N56FASilver Express Co DBA · Miami, FLBuilt 1978 · S/N 172-69682N56FDDefibaugh Fred M · Chino Alley, AZS/N 3535N56GBCalhoun Keith A · Springville, TNBuilt 1997 · S/N 56N56GKMatan Kai LLC · West Hollywood, CAS/N 414A0847N56GLRainosek Kevin · Granbury, TXBuilt 1994 · S/N EA-572N56GTDonaldson Timothy A · Oklahoma City, OKBuilt 1976 · S/N AA5B-0344N56GUIdagus N56gu LLC · Miami, FLBuilt 2022 · S/N 18283208N56HDouble D International LLC · Miami, FLBuilt 1977 · S/N 414-0941N56HCFaire Ken · Mojave Valley, AZBuilt 1976 · S/N 2N56HEYork Philip S · Sedro Woolley, WABuilt 2014 · S/N E-4043N56HJRobinson Douglas J · Dayton, NVBuilt 1997 · S/N 24348N56HMBarrett Keith Alan · Anniston, ALBuilt 1984 · S/N TJ-466N56HRStrachan Annmarie C · Overgaard, AZBuilt 2002 · S/N 81408N56HYCipolli Robert J · Montgomery, MABuilt 2003 · S/N 2222N56JDDignan Charles N · Telluride, COBuilt 1976 · S/N 1N56JKStalp Ag Leasing LLC · Fremont, NES/N TC-1938N56JLSea Air Inc · Wilmington, DEBuilt 1977 · S/N D-10094N56JSPoppy Wayne J · New London, WIFirst renewal noticeS/N 1001N56JUSurfield Ronald W · Leonardtown, MDS/N 22159N56KCCrawford William K · Ovilla, TXBuilt 2004 · S/N T018N56KMBudake LLC · Macon, GABuilt 1983 · S/N TH-1391
Back to AD 2007-04-19 R1