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.

N460FLHillenbrand Sean P · Westminster, CABuilt 1971 · S/N 28-7125257N460JBLipscomb Richard L · Bowie, TXBuilt 2001 · S/N 690-320-434N460JCCopper River Airmotive LLC · Copper Center, AKBuilt 2006 · S/N 2343N460JPNewman Charles · Petaluma, CABuilt 2003 · S/N L2K-204N460LELeading Edge Flight Academy LLC · Bend, ORBuilt 2006 · S/N 4060N460LMMassey Larry A · New Braunfels, TXBuilt 1977 · S/N 321-77N460LZChapman Daniel W · Soldotna, AKBuilt 1983 · S/N 460N460NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881655N460PHRicter Edward T · Fairbanks, AKBuilt 1988 · S/N 7493CN460RWicklund Gerald G · Liberty, MOS/N 18267786N460SAN460sa LLC · Brea, CABuilt 2006 · S/N 11558N460SCFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 4496551N460TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881860N460TJVertical Ventures Aviation LLC · Franconia, NHBuilt 2012 · S/N 13377N460UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020163N460WPoling Barry · Texline, TXBuilt 1965 · S/N 18256773N460WWMalibu Ww LLC · Fayetteville, GABuilt 1986 · S/N 46-8608022N460XSkyblue Aviation Cr Inc · Merritt Island, FLBuilt 1978 · S/N 28-7816581N460YRMathias Lee R Trustee · Sebastopol, CABuilt 2009 · S/N E-3890N46100Aerflow Inc · Jersey City, NJBuilt 1968 · S/N 17257041N46101Patel Aman · Wesley Chapel, FLBuilt 1968 · S/N 17257042N46107Trieber Steven M · Eastport, MEBuilt 1968 · S/N 17257046N46109Pray Aviation Inc · Augusta, KSBuilt 1968 · S/N 17257047N4610AHorn Paul · Kodiak, AKBuilt 1955 · S/N 32208N4610BHuber Gregory A · Medina, OHBuilt 1955 · S/N 31508N4610DWolf Gary J · College Grove, TNBuilt 1997 · S/N 22062N4610KAvag Inc · Richvale, CABuilt 1979 · S/N P21000235N4610QBlaire William C · Rch Palos Vrd, CABuilt 1973 · S/N 17261725N4610RClick Dennis R · Seattle, WABuilt 1965 · S/N 28-21359N4610WTen Right Aviation LLC · Abbeville, LAS/N TH-1378N4610YPanama City Cycles Inc · Panama City, FLBuilt 1971 · S/N 18-8940N46115Capri Aircraft LLC · Madison, VABuilt 1968 · S/N 17257049N46118Epiphany Software Co · Wilmington, NCBuilt 1968 · S/N 17257051N46119Parrish Aviation Flight Academy LLC · Southlake, TXBuilt 1968 · S/N 17257052N4611EFife Jeffrey Ryan · Seminole, FLS/N 18503813N4611FRandall Jason · Woodstock, ILBuilt 1966 · S/N P206-0211N4611REdwards Ruben W · Mesa, AZBuilt 1966 · S/N 28-21360N4611WPhillips James E · Mammoth Lakes, CAS/N 13101N46122Martin Gregory C Jr · Homer, AKFirst renewal noticeBuilt 1968 · S/N 17257054N46125East Carolina Aviation LLC · Camden, NCBuilt 1968 · S/N 17257056N46126Knight Kenneth D · Stoneville, NCBuilt 1968 · S/N 17257057N46128Meridian Aircraft Leasing LLC · Anniston, ALBuilt 1968 · S/N 17257059N4612BBenson Ian M · Portland, ORBuilt 1955 · S/N 31510N4612DPrecision Flight Training Inc · Newberg, ORBuilt 1979 · S/N 17272315N4612KChitiea Andrew D · Centennial, COBuilt 1979 · S/N P21000236N4612SWooddale Kirby LLC · Edina, MNBuilt 1958 · S/N D5517N4612UBauman Raymond S · Douglas, WYS/N 18051312N4612YGrasshopper Aviation LLC · Tulsa, OKBuilt 1971 · S/N 18-8933N46130Waltzer Eric · Riverside, CABuilt 1968 · S/N 17257061N46132N46132 Leasing LLC · Kalispell, MTBuilt 1968 · S/N 17257063
Back to AD 2007-04-19 R1