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.

N30AGAlaskan Outdoors LLC · Soldotna, AKBuilt 1994 · S/N 4131CN30AKRomanski Jack · Berkeley, CABuilt 1996 · S/N 21153N30AMRoth Douglas D · Lincoln, NEBuilt 1982 · S/N 248N30AWKnox Tommy J · Lampasas, TXBuilt 1974 · S/N 18502369N30BMagill Terry K · Beach City, TXBuilt 1966 · S/N 30-1381N30BKLoeppky Neal K · Seminole, TXS/N 002N30BMMoore William E · Franktown, COBuilt 2019 · S/N PT 1090N30CAState Of California Department Of Transportation · Sacramento, CABuilt 1974 · S/N CE-508N30CEWren Aircraft LLC · Menlo Park, CABuilt 2003 · S/N 0001N30CHSale Reported · Maiden, NCSale reported, pending cancellationBuilt 2026 · S/N 4944N30CMBoardman Air Service LLC · Henderson, NEBuilt 1974 · S/N 18502443N30CSAdams Brad A · Soldotna, AKBuilt 1957 · S/N 18-5409N30CTLaidley Robert F · Erie, COBuilt 1978 · S/N 182-66446N30CWBrownd Gregory H · Shallowater, TXBuilt 1958 · S/N D-5636N30DDRegenstein Jacob · San Francisco, CABuilt 1992 · S/N 20349N30DMNagle Derek · Ada, MIBuilt 1979 · S/N E-1536N30DSSaver Matthew S · Lebanon, TNBuilt 2003 · S/N 81482N30DWHeffernan Michael James · Wellesley, MABuilt 1971 · S/N 28R-7135229N30ECVogt Timothy J · Houston, TXBuilt 1997 · S/N 1284N30EDN30ed LLC · Carpinteria, CABuilt 1969 · S/N D-9076N30EEEnterprises Aviation Inc · Piedmont, SDBuilt 1979 · S/N 414A0443N30ERRance Cory · Moody, TXBuilt 2020 · S/N T-169N30ETZaldivar Carlos · Miami, FLBuilt 1971 · S/N 310Q0266N30EWThree Zero Echo Whisky Inc · Wilmington, DEBuilt 1976 · S/N 21061412N30FATerra Ferma Inc · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1963 · S/N 30-59N30FBBmg Aviation Leasing LLC · Bloomington, INBuilt 1978 · S/N 414A0067N30FCState Alabama Forestry Commission · Florence, ALFirst renewal noticeBuilt 1982 · S/N R18201913N30FHBaldwin Jonathan B · East Boothbay, MEBuilt 1973 · S/N 34-7350203N30FMM20j LLC · Niceville, FLBuilt 1997 · S/N 24-3410N30GHAvientur LLC · Chesterfield, MOBuilt 2007 · S/N E-3761N30GSClausen Robert G · Argyle, MNBuilt 1973 · S/N 17261470N30HCKinetic Concepts LLC · Pensacola, FLS/N 310Q1079N30HUDukes William R · Tallulah, LABuilt 1998 · S/N 1406N30JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1976 · S/N 17268043N30JBBalbierer John M · Columbus, MSBuilt 1998 · S/N 23892N30JGAdamson Don · Lonoke, ARBuilt 1976 · S/N 1369N30JKThompson Troy L · Amarillo, TXS/N 732N30JPPhilpott Connor J Ryan · Newbury Park, CABuilt 1977 · S/N 1-0052N30JSFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1977 · S/N 28R-7837100N30JTMatthews William P · Blacksburg, VAS/N 80903N30JVJasper Aviation Inc · Jasper, ALBuilt 1964 · S/N TD-597N30JXOptimal Aviation Services LLC · Visalia, CABuilt 1964 · S/N 30-539N30KJCrist Carry R · Crete, NEBuilt 1957 · S/N D-5181N30KWWeeks Kermit A · Polk City, FLBuilt 1974 · S/N 003N30LERollins Robert · Gadsden, ALBuilt 1971 · S/N 28R-7235018N30LFSignalwave LLC · Doral, FLBuilt 1980 · S/N EA-122N30LGHusky Two Associates LLC · Brookline, MABuilt 2020 · S/N E-4145N30LNRaymon Rodherick L · Enterprise, ALBuilt 2002 · S/N 40046N30LPDialysis Clinic Inc · Nashville, TNBuilt 1977 · S/N 310R0995N30LVNorth Arkansas Aviation LLC · Paragould, ARS/N 28-7916098
Back to AD 2007-04-19 R1