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.

N3YHarding Mike R · Ventura, CABuilt 1961 · S/N 1N3YBMonroe Andrew P · Reno, NVBuilt 1976 · S/N 76-564N3YHMarsaudon David · Friday Harbor, WABuilt 2002 · S/N 0239N3YMLoftin Scott M · Rosamond, CABuilt 2001 · S/N 3223N3YNWeaver Carl · Halstead, KSS/N 18051477N3YPAstmann Roger J · North Haven, CTBuilt 1966 · S/N CE-32N3YRStone Charles Douglas · Cedarville, OHBuilt 1975 · S/N 18-7509113N3YSAdams Harry J · New Waverly, TXS/N 916N3YUT2 Aviation LLC · Missouri City, TXBuilt 2004 · S/N 18281453N3ZAMorgan James P · Arlington Heights, ILBuilt 1995 · S/N 0693N3ZEZephyr Enterprises Inc · Wilmington, DEBuilt 1968 · S/N NAV-4-2520N3ZGIsbell Tony A · Rainbow City, ALS/N 1572N3ZRRegistered aircraftBuilt 1973 · S/N 1048N3ZWMicle Florin · Cedar Park, TXS/N 23241N40004Tennesen James B · Menomonie, WIBuilt 1977 · S/N 28R-7737126N40005Williams Brian · Rhinebeck, NYBuilt 1977 · S/N 28-7716312N40006Kotwal Pramod · Bedford, MABuilt 1977 · S/N 28-7716314N40007Kelleher Timothy J · Lake Placid, NYS/N 182-61875N40008Birkland Mitchell L · Lake Jackson, TXBuilt 1977 · S/N 28-7716317N4000DHortman Jennifer L · Murrieta, CABuilt 1958 · S/N 51361N4000JThomas Harold C · Fall River Mills, CABuilt 1960 · S/N 39134N4000LUrquhart Ken · Wedowee, ALBuilt 2013 · S/N E-4000N4000MDonair LLC · Enid, OKBuilt 1962 · S/N M-90N4000WN4000w LLC · Prescott, AZBuilt 1974 · S/N TE-1004N4000XJp Skyward LLC · Ontario, CABuilt 1998 · S/N 172S8010N4000ZAmstrup Jeremy T · Fairbanks, AKBuilt 1963 · S/N 18-7951N40010Sain Ricky F · Vale, NCS/N 28R-7737127N40014Ar Racing Inc · Catawba, NCBuilt 2025 · S/N 2825N40015Wings Flying Club Inc · Sheperdsville, KYBuilt 1977 · S/N 28-7716319N40016Miller Aircraft Services Inc · Crookston, MNBuilt 1977 · S/N 28-7716320N40017Biro Of Chicago Inc · Chicago, ILBuilt 1977 · S/N 28-7716321N40019Registered aircraftBuilt 1977 · S/N 28-7716322N4001DJohnson Randall S · Craig, AKBuilt 1957 · S/N 34701N4001LRobinson Helicopter Co · Torrance, CABuilt 1990 · S/N 1331N4001SLeckonby David · Waterford, NYS/N TC-1817N4001YHill James J · Saint Helen, MIBuilt 1961 · S/N 1850201N4001ZPayne Ronald J II · Wasilla, AKBuilt 1963 · S/N 18-7952N40021Zieber Josh · Leesville, LAS/N 28-7716323N40023Stice Garrett · Summit, ARBuilt 1977 · S/N 28-7816002N40024Teton Leasing LLC · Pocatello, IDBuilt 1977 · S/N 28R-7737128N4002DVanburen Willard L Sr · Ashland, NEBuilt 1957 · S/N 34702N4002FDoyle Patrick T · Fond Du Lac, WIBuilt 1955 · S/N G-779N4002KSummerskyz Inc · Urbana, ILBuilt 1990 · S/N 1390N4002ZTappen Farm Supply Inc · Tappen, NDBuilt 1963 · S/N 18-7953N40030Cantrell James E Trustee · Decatur, GAFirst renewal noticeBuilt 1998 · S/N 21052CN40037Pars Avn Corp · Wilmington, DES/N 28-7816003N4003ATurboair Inc Owner Trustee · Wilmington, DES/N 30002CN4003BHenderson James A · Flomaton, ALBuilt 1974 · S/N 75-30730N4003GButler Donald D · Petersburg, PABuilt 1990 · S/N 1459N4003TCorey Jason R · Meridian, IDBuilt 1968 · S/N M-1109
Back to AD 2007-04-19 R1