OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,428

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.

N17LCGilpin Kevin E Trustee · Weston, MABuilt 1972 · S/N TC-1474N17LDKlusmier Lawrence A · Shickshinny, PAS/N 21385N17LFBrown-Elliott Candice · Santa Rosa, CABuilt 1972 · S/N 28-7325183N17LGGreen & Green Construction Of Grenada Inc · Grenada, MSBuilt 1966 · S/N TE-204N17LVMountain Cascade Inc · Livermore, CABuilt 2015 · S/N E-4062N17MABearden James D · West Point, MSS/N D-7529N17MBAerocorp LLC · San Antonio, TXBuilt 1966 · S/N 30-1215N17MDMoyer David · Katy, TXBuilt 1966 · S/N 32-552N17MMBekanich Jason · Camden, NCBuilt 1967 · S/N 18258323N17MPMalone Mark R · League City, TXBuilt 1973 · S/N 7N17MVNorthwestern Michigan College · Traverse City, MIBuilt 2020 · S/N 172S12598N17NAHampden Aviation Services Inc · Northampton, MABuilt 1983 · S/N 28-8316067N17NEWilson James M · Scottsdale, AZS/N 18-7709083N17NGParmer Construction Company LLC · Terrell, TXBuilt 1987 · S/N 4608074N17NJCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 17274527N17NLAerospatial Systems LLC · Boulder, COBuilt 1995 · S/N 014N17NWEye Clinic Building Lllp · Bismarck, NDBuilt 1979 · S/N 414A0223N17PFlying M LLC · Reno, NVBuilt 2008 · S/N 23106CN17PBPort Townsend Aero Museum · Port Townsend, WABuilt 1970 · S/N 7N17PCCarolina Seaplanes LLC · Tega Cay, SCFirst renewal noticeBuilt 1958 · S/N 22-5931N17PDSelph William D · Broxton, GABuilt 1994 · S/N 1675N17PEEberle Paul R · Topanga, CABuilt 1996 · S/N PE001N17PKSmith Kevin B · Camden, NCBuilt 1964 · S/N D-7515N17PQStory Brian J · Noblesville, INS/N 1611N17PTLinn Robert · Houston, TXBuilt 1995 · S/N 2511N17PWPastron Willard P · Camano Island, WABuilt 1988 · S/N 5148N17PZPro-Air Of Oakland Inc · Birmingham, MIBuilt 1981 · S/N 28-8190255N17REFarina Richard H · Ashburn, VAS/N CE-1128N17RNOgopogo Foundation · Sonora, CAFirst renewal noticeBuilt 1976 · S/N 28-7790162N17SEcho Sierra LLC · Lawrenceburg, TNBuilt 1998 · S/N 3246N17SLTastad Joel M · Hager City, WIBuilt 1997 · S/N 1368N17SMN17sm LLC · Coral Springs, FLS/N 17272967N17SNWindspeed LLC · Amarillo, TXBuilt 2001 · S/N 0115N17SQL R & T LLC · Midlothian, TXBuilt 1978 · S/N GA7-0017N17SRNcsb LLC · Anchorage, AKBuilt 1974 · S/N 18502424N17TARetired Aviators Flying Club LLC · Oklahoma City, OKBuilt 1961 · S/N 24-2652N17TCKenyon Walter C · Eureka Springs, ARBuilt 1964 · S/N 21058499N17TGGeesman John T · Mason City, IAS/N 1373N17TTThompson Thomas K · Granville, OHBuilt 2019 · S/N 001N17UAce Flight LLC · Houma, LABuilt 1964 · S/N 310I0093N17UBHannemann James R · Mercer, WIBuilt 1948 · S/N 5947N17UKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2002 · S/N 0200N17UPRhinelander Flying Service Inc · Rhinelander, WIBuilt 1974 · S/N 17263440N17USMarmac Inc · Hellertown, PABuilt 1976 · S/N E-851N17WAKaestner Henry Todd · Franklin, TNBuilt 2020 · S/N 92284N17WEMckinney Joe M · Tuscumbia, ALBuilt 1978 · S/N 27-7854118N17WFDraper Russell E · Camarillo, CABuilt 1978 · S/N D-10191N17WJAngel Wings Flyers LLC · Wilson, NCBuilt 1964 · S/N 2881N17WKOhnigian Steven P · Castle Rock, COS/N 2158N17WPNorthern Indiana Twin LLC · Valparaiso, INBuilt 1964 · S/N TC-578
Back to AD 2007-04-19 R1