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.

N465CTMatter Terrence K · Reno, NVBuilt 1963 · S/N 18254800N465CWSkyking LLC · Lake Stevens, WABuilt 1963 · S/N 310H0134N465DLKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1979 · S/N 310R1622N465EPRainier Flight Service LLC · Renton, WABuilt 2015 · S/N 172S11606N465FARondeau Inc · East Norriton, PABuilt 2022 · S/N 28020065N465HMMorse Don W DBA · Priest Lake, IDS/N 50394N465KBBelue Kevin D · Madison, ALBuilt 2008 · S/N 40261N465PEHoyle Jason R · Grove, OKBuilt 1966 · S/N TE-112N465SAGilmore Air LLC · Boca Raton, FLBuilt 2002 · S/N E-3465N465TByrds Wholesale Inc · Clayton, NCS/N 18260715N46601Skywarrior Flight Training Inc · Pensacola, FLFirst renewal noticeBuilt 1968 · S/N 17257377N4660AConnealy Air LLC · Whitman, NES/N 32257N4660BEllison Orlo T · Broomfield, COBuilt 1955 · S/N 31558N4660DSale Reported · Milwaukee, WISale reportedBuilt 1956 · S/N D-4885N4660GAdvantage Aviation Inc · Palo Alto, CABuilt 1979 · S/N 17273286N4660JStuder Al C · Shelby, MIBuilt 1980 · S/N T18803759TN4660KFoster Gary Paul · Willow, AKS/N 18263662N4660NCasey Kellie M DBA · Fort Worth, TXBuilt 1979 · S/N 18267285N4660ROgren William E · Red Wing, MNBuilt 1966 · S/N 28-21415N4660YManess Gary D · Eagle River, AKS/N 18-8948N46612Dugger Joey D · Nine Mile Falls, WABuilt 1968 · S/N 17257383N46613Mad Cap Inc · Smithfield, RIBuilt 1968 · S/N 17257384N46615Lindsay William G · Santa Paula, CAFirst renewal noticeBuilt 1968 · S/N 17257385N46616Koubsky Richard L · Hollywood, SCBuilt 1968 · S/N 17257386N4661AOlson Eric T · Hudson, WIBuilt 1956 · S/N 32258N4661CZiesmer Richard A · University Place, WABuilt 1974 · S/N 18502589N4661MF & W Aviation Co LLC · Wilmington, DEBuilt 1978 · S/N E-1249N4661RSternberg Alexander J · Key Largo, FLBuilt 1966 · S/N 28-21416N4661TPowell Christopher T · Moosic, PAS/N R18201727N4661ZRustair Inc · Anchorage, AKBuilt 1980 · S/N U20605998N46620Cantrell Jason L · Aberdeen, MSBuilt 1968 · S/N 17257387N46621Lake Clark Holdings LLC · Port Alsworth, AKBuilt 1968 · S/N 17257388N46622Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 17257389N46624Kda Aviation LLC · East Granby, CTFirst renewal noticeBuilt 1968 · S/N 17257391N46629Brock Robert L · Tonganoxie, KSBuilt 1968 · S/N 17257394N4662EJgm Aviation LLC · Marion, MTFirst renewal noticeS/N 18268256N4662JBigby Calvin J · Savannah, GAS/N 28R-30558N4662PCorn Michael L · Wilmington, NCBuilt 1960 · S/N 27-185N4662UMeadow Lakes Aviation · Wasilla, AKBuilt 1964 · S/N 18051362N46631Keenan Joseph P · Fort Lauderdale, FLBuilt 1968 · S/N 17257396N46632Dehn Charlene M · Victor, NYBuilt 1968 · S/N 17257397N46636King James E · Port Angeles, WABuilt 1968 · S/N 17257399N46638Pro Aviation LLC · Sanger, TXBuilt 1968 · S/N 17257401N4663CKnox William D · Denver, COBuilt 1974 · S/N 18502590N4663JMetro Flying Club · Gilbert, SCBuilt 1968 · S/N 28R-30559N4663RLockwood Michael C · Edmond, OKBuilt 1966 · S/N 28-21418N4663WMoeller Thomas R · Evergreen, COBuilt 1977 · S/N 13193N46640Bryant William S · Kilmarnock, VABuilt 1968 · S/N 17257403N466421028 Flying Club LLC · Statesville, NCBuilt 1968 · S/N 17257405N46643Volunteer State Aviation LLC · College Grove, TNBuilt 1968 · S/N 17257406
Back to AD 2007-04-19 R1