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.

N5368JJones Anesthesia LLC · Arcadia, INBuilt 2003 · S/N 2843551N5368PHeck Paul A · Santa Rosa, CABuilt 1958 · S/N 24-417N5368TAviation Here LLC · Lino Lakes, MNS/N 28-7205260N5368UBornwasser Louis W · Prospect, KYBuilt 1984 · S/N 21064880N5368WFuller Jonathan T · San Antonio, TXFirst renewal noticeBuilt 1962 · S/N 28-433N5369AMartens Charles H · Nokomis, FLBuilt 1979 · S/N 21063395N5369DBrown Hector M · Glenwood Springs, COBuilt 1958 · S/N 50267N5369EKing Curtis M · Tenino, WABuilt 1959 · S/N D-5850N5369NDecio Justin M · Portsmouth, NHBuilt 1980 · S/N 18267668N5369RArmbruster LLC · Amherst, OHBuilt 1979 · S/N 172RG0058N5369YPollard William Edward · Big Spring, TXBuilt 1980 · S/N 21064185N536AMTriniair LLC · Warner Robins, GABuilt 1978 · S/N E1172N536BBBas Air LLC · Valparaiso, INBuilt 2008 · S/N E-3854N536CMCherry Hill Aviation Inc · Freetown, INBuilt 2022 · S/N 1202-2022N536EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2024 · S/N 172S13171N536EUSarabay Aviation Partners LLC · Sarasota, FLBuilt 2005 · S/N E-3616N536GRNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282182N536GSLvhbj LLC · Portola Valley, CABuilt 2011 · S/N E-3948N536GTNorthern Planes Aerosport LLC · Algona, IABuilt 2012 · S/N 536N536JRSale Reported · Port Orange, FLSale reportedBuilt 1973 · S/N 17262831N536JSShoffner James P Jr · Denver, COBuilt 1984 · S/N EA-418N536KEngage Helicopters LLC · Sarasota, FLS/N E3220N536KSKent State University · Stow, OHBuilt 2025 · S/N 172S13365N536LAhmed Ejaz DBA · Carrollton, GABuilt 2017 · S/N 18283023N536MAWilliams Fertilizer Services LLC · Oregon, MOBuilt 2004 · S/N 1378-2004N536MMTroyer David · Newnan, GAS/N 20753N536NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10932N536PSky High II LLC · Clinton, NCBuilt 1998 · S/N E3197N536PUMetro Aircraft Co · Bloomington, MNBuilt 1992 · S/N 2841321N536SN5405a LLC · Beverly Hills, CABuilt 2004 · S/N 60478N536SHCentral Ky Ag Air LLC · Harrodsburg, KYBuilt 2006 · S/N 11325N536TCI C Aviation LLC · Scottsdale, AZBuilt 1988 · S/N EA-481N536THLanier Equipment Leasing LLC · Gainesville, GABuilt 2021 · S/N 172S12636N536TPDownhill Aero LLC · Kalispell, MTBuilt 1999 · S/N 4636212N536WWright Jack · Fortson, GABuilt 2002 · S/N E-3458N536WCN8qb LLC · Thief River Falls, MNBuilt 1972 · S/N 21059794N536WGAdvantage Aviation Inc · Palo Alto, CABuilt 1990 · S/N CE-1446N536XDel Rio Aviation Inc · Paso Robles, CABuilt 1977 · S/N 170574N53703University Of Michigan Flyers Inc · Ann Arbor, MIBuilt 1981 · S/N 17274804N5370DWhitten Wayne M Sr · North Berwick, MEBuilt 1958 · S/N 50268N5370ESwanson Philip A · Star, IDBuilt 1980 · S/N 18503958N5370FRegistered aircraftBuilt 1976 · S/N 28R-7635460N5370LSouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1968 · S/N 28-4676N5370PBlythe Anne T · Paso Robles, CABuilt 1958 · S/N 24-420N5370TK.M. Biggs Inc · Lumberton, NCBuilt 1972 · S/N 28R-7235228N5370UPogany Steve C · Anchorage, AKBuilt 1979 · S/N U20605251N5370WAllen Lanny Dean · Indianapolis, INS/N 28-435N53713Haley Wendell B · Williamson, GABuilt 1975 · S/N 531-75N53718Seals James E · Oxford, ALBuilt 1975 · S/N 867-75N53719Allen Scott P · Wellington, NVBuilt 1975 · S/N 858-75
Back to AD 2007-04-19 R1