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.

N492RVRegistered aircraftBuilt 2014 · S/N 91233N492SFSnohomish Flying Service Inc · Snohomish, WABuilt 1976 · S/N 17268310N492SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 172S8033N492TZuestek Inc · Diana, TXBuilt 1960 · S/N D-6597N492TCMckinley Matthew · Sault Sainte Marie, MIBuilt 1971 · S/N 30362N492WAirplane Adventures LLC · Palos Heights, ILBuilt 1956 · S/N 23-611N492WPAngel Aviation Inc · Peoria, AZBuilt 1979 · S/N 17272684N492XMcdonald Stuart D · Phoenix, AZS/N REA-001N49305Everything Pitts LLC · Queen Creek, AZBuilt 1981 · S/N 1000N49306Mercer Mark E · Aurora, COBuilt 1981 · S/N 1001N49307Lutes David W · Berryton, KSBuilt 1981 · S/N 1002N49309Newton Thomas L Jr · Fredericksburg, VABuilt 1982 · S/N 1006N4930ACapra Cory · Forest Lake, MNBuilt 1956 · S/N 32327N4930LG Salisbury & Associates Inc · Prescott, AZBuilt 1967 · S/N 28-4297N4930NOneill Aviation LLC · Lake Wales, FLBuilt 1977 · S/N 21062421N4930PRegion Flyers LLC · Valparaiso, INS/N 27-523N4930RSouther Field Aviation Inc · Americus, GABuilt 1975 · S/N 18802447TN4930UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842241N4930VCirrusly LLC · Bonney Lake, WABuilt 2004 · S/N 0960N49312Boyd Timothy · East Point, KYBuilt 1982 · S/N 1008N49314Losacker Matthew S · Chandler, AZBuilt 1983 · S/N 1014N49315Morphew Ben · Mckinney, TXS/N 1013N49319Anderson Richard P · De Leon Springs, FLBuilt 1985 · S/N 1029N4931CEinstein Inc · Price, UTBuilt 1975 · S/N 18502662N4931LThrust Spear Of Tampa LLC · Tampa, FLBuilt 1967 · S/N 28-4299N4931RRegistration Pending · Westhope, NDRegistration pendingBuilt 1975 · S/N 18802448TN4932ALegas David S · Phoenix, AZBuilt 1956 · S/N 32329N4932JDunlap Aviation Inc · Dunlap, ILBuilt 1968 · S/N 28R-30653N4932NSan Juan Flyers Inc · Pagosa Springs, COBuilt 1979 · S/N 18267460N4932SThunder Aviation LLC · Oro Valley, AZBuilt 1980 · S/N R18201471N49330Cjw Hydrodynamics Inc · Fresno, TXBuilt 1986 · S/N 1035N49331Plane Fun Inc Tr Trustee · Snellville, GAS/N 1038N49332Blue Eagle Pitts LLC · Tempe, AZS/N 1039N49335Van Cleave Raymond D · Kalispell, MTBuilt 1986 · S/N 5102N49336Krieger Heinz Friedrich · FrenkendorfS/N 1045N49337Herrmann Ralf D · DahlemBuilt 1986 · S/N 1046N49338Bakker Matthew G · Ellington, CTBuilt 1986 · S/N 1044N49339Goble John H · Cresson, TXBuilt 1987 · S/N 1047N4933JRegistration Pending · Columbia, SCRegistration pending, pending cancellationBuilt 1968 · S/N 28R-30654N4933LSouthall Charles B · Amelia, OHS/N 28-4301N4933QDarter Lloyd R · Mountain Grove, MOBuilt 1976 · S/N 18802668TN4933SHedden Larry H · Huntsville, ALBuilt 1980 · S/N R18201334N49340Butler Tracey D · Buckley, WABuilt 1987 · S/N 1048N49348Benner Tristen · Opheim, MTBuilt 1991 · S/N 1194N49349Rankin Ty · Amarillo, TXBuilt 1991 · S/N 1196N4934AYellowstone Overflight Inc · Belgrade, MTBuilt 1956 · S/N 32331N4934EHeineman Steven · Chicago, ILBuilt 1979 · S/N 18503912N4934FAffordale Aviation Corp · Moriches, NYBuilt 1976 · S/N 28-7715082N4934LFlyboys LLC · Orange, VABuilt 1967 · S/N 28-4302N4934PAlm Holding LLC · Winton, CABuilt 1963 · S/N 27-527
Back to AD 2007-04-19 R1