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.

N44597Tob Cherokee Flyers · Kasson, MNBuilt 1974 · S/N 28-7525001N4459HClements Edward L · Fruita, COBuilt 1978 · S/N 24-0740N4459JCoastal Virginia Aviation LLC · Chesapeake, VAS/N 28-22868N4459SJameson Kelly J · Chappell Hill, TXBuilt 1975 · S/N E-692N445ACTholen Susan M · Kennebunk, MEBuilt 1998 · S/N 389-98N445AFPlane Nonsense Inc · Middletown, DEBuilt 1998 · S/N 17280445N445BDornoch Services LLC · Dover, DEBuilt 2005 · S/N 172S9776N445BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2021 · S/N 4496527N445BLBlue Line Aviation LLC · Smithfield, NCBuilt 2025 · S/N 4496599N445CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13248N445CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282356N445DChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8264N445DCWith Wings As Eagles Aviation LLC · Middletown, DEBuilt 1975 · S/N 18263690N445DHOhio University · Albany, OHBuilt 2005 · S/N 2842233N445HPChopra Family Lp · Tulare, CABuilt 1985 · S/N EA-445N445HSBas Part Sales LLC · Greeley, COS/N 13312N445JSAg Ranch Services LLC · Lewistown, MTBuilt 2012 · S/N 13278N445KCCramer Kirby · Fallbrook, CABuilt 2004 · S/N 70121N445KPHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2007 · S/N 11693N445KSPeraton Services LLC · Bozeman, MTBuilt 2020 · S/N 172S12534N445MGGeorgia Aviation Authority · Eastman, GABuilt 2025 · S/N 4496598N445MKNorth Star Aviation · Mankato, MNBuilt 2015 · S/N 4496383N445NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 2881891N445PWelsh Steven M · Oxford, NCBuilt 2001 · S/N E-3415N445PASkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843500N445RDensmore John L · Conway, WABuilt 1974 · S/N 17262596N445RFRichards Jacob · Mount Olive, NCBuilt 2011 · S/N 60385N445SPGasman401 Aviation LLC · Punta Gorda, FLBuilt 1964 · S/N 481N445WTClayton Edwin G · North Chesterfield, VABuilt 1964 · S/N 2776N445YSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1951 · S/N 22817N445ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881672N44604Lydic Daniel · Pittsburgh, PABuilt 1974 · S/N 28-7425431N44605Luitjens Jacob J · Lagrange, GABuilt 1974 · S/N 28-7415681N4460AHvizdak George D · Colliers, WVS/N 22-3793N4460S300 Dollar Burger LLC · Elmhurst, ILBuilt 1975 · S/N E-691N4460TRuff Randall N · Bay City, MIBuilt 1972 · S/N 28-7225147N4460XStingray LLC · Pensacola, FLBuilt 1975 · S/N 28-7615014N4460YQuality Aviation Inc · Marana, AZBuilt 1966 · S/N 25-4109N44614Swair LLC · Denver, COBuilt 1974 · S/N 28-7405265N4461744617 LLC · Post Falls, IDBuilt 1974 · S/N 28-7410100N44618Word Howard W Trustee · Kula, HIBuilt 1974 · S/N 32-7400051N4461AOrtwein Mathew M · Reedsport, ORBuilt 1956 · S/N 22-3794N4461BGaylor Steven C Trustee · Ramona, CABuilt 2009 · S/N 81994N4461HJohnson Airspray Inc · Argyle, MNBuilt 1978 · S/N 24-0742N4461JBoyd Eric L · Stuart, FLBuilt 1967 · S/N 28-22875N4461TRobinson Joseph B · Washington, DCBuilt 1972 · S/N 28R-7235058N4461VAimo Joseph Ray · Bountiful, UTS/N 872N4461WKimball Douglas S · Bedford, INBuilt 1974 · S/N TC-1677N4461XHaggerty James D · Scott Depot, WVBuilt 1975 · S/N 28R-7635051N4461YRubbert Jan D · Upham, NDBuilt 1966 · S/N 25-4111
Back to AD 2007-04-19 R1