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.

N3448PDabney Richard W · Tanner, ALBuilt 1958 · S/N 23-1419N3448QSand Hill Ranch Ltd · Decatur, TXBuilt 2011 · S/N 22030CN3448RFour Eight Romeo LLC · Shallowater, TXBuilt 1967 · S/N 18258748N3448UHigh Planes Flyers Inc · Fort Collins, COBuilt 1963 · S/N 18254848N34490Peterson Frazer C Trustee · Payette, IDBuilt 1972 · S/N 17701838N34491Hazelwood Dennis L · Mount Vernon, MOBuilt 1972 · S/N 17701839N3449FKunkel John A · Pine River, MNS/N 18257449N3449MCarhart Thomas M · Galesville, WIBuilt 1977 · S/N 28R-7837114N3449RRobinson Timothy A · Casa Grande, AZBuilt 1967 · S/N 18258749N3449THedrick Bill E · Kilgore, TXBuilt 1968 · S/N 17700749N3449UHicks Brian Joseph · Shingle Springs, CABuilt 1963 · S/N 18254849N3449YSteel Rock Aviation LLC · West Jordan, UTBuilt 1968 · S/N 18051949N344AHAdams Flying Service Inc · Rayville, LABuilt 1978 · S/N 310R1371N344AJQualitair LLC Trustee · MichelstadtBuilt 1980 · S/N 21063891N344AKChavi LLC · Fredericksburg, TXBuilt 2008 · S/N 12166N344ATTagir Abkadirov · Tampa, FLS/N 1354N344BCote Stephen P · Montgomery, TXS/N D-4953N344BAWoodring Mark W · ProvidencialesNon-citizen corporation, flight hours not reportedS/N 0570908N344BBMansfield Heliflight · Milton, VTBuilt 2001 · S/N 1159N344BHBlack Hills Aviation Leasing LLC · Rapid City, SDBuilt 2024 · S/N 14763N344BLWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 4496582N344CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282137N344CCDorsey Dale · Charlotte, NCBuilt 1995 · S/N 22084N344CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2002 · S/N 0156N344CFKey West Helicopters LLC · Key West, FLBuilt 2004 · S/N 10440N344CRPattern Altitude Aviation Standards LLC · Sandy, UTS/N 28-153N344DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843832N344ESLake Superior Helicopters LLC · Duluth, MNBuilt 2015 · S/N 2402N344GStobbe Marlin · Ethridge, TNBuilt 2003 · S/N 10099N344JEAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13472N344JGSmith Helicopters Inc · Cotulla, TXBuilt 2008 · S/N 12128N344JPCentral Virginia Aviation Inc · North Dinwiddie, VAS/N 35713N344JSWhitewing Aviation LLC · Tuscola, TXBuilt 1979 · S/N 340A0781N344KLeblanc Debrah · Zachary, LABuilt 1975 · S/N 18263709N344KVLutz Gregory J · East Bridgewater, MABuilt 1960 · S/N 57470N344LCDuyk Charles W · Saint Petersburg, FLBuilt 2018 · S/N 2564N344LRRotor Scooter LLC · Hauppauge, NYBuilt 2024 · S/N 14801N344MARomeo Romeo LLC · Lewes, DEBuilt 2003 · S/N 40.344N344MGAir Service LLC · Wilmington, DEBuilt 2014 · S/N 13730N344MTPalomino Creek LLC · Missoula, MTBuilt 2013 · S/N 13560N344PCFlorida Cap Property Management Services LLC · Fort Lauderdale, FLBuilt 2023 · S/N 14680N344RBContinental Aerospace Technologies Inc · Mobile, ALBuilt 2011 · S/N 172S11133N344RLRed R44 LLC · Wilmington, DEBuilt 2019 · S/N 2598N344SRegistered aircraftBuilt 1972 · S/N TH-210N344SAShier Aviation DBA · San Diego, CABuilt 2017 · S/N 30012N344SGGoldman Glenn D · VaughanBuilt 1957 · S/N BG354N344SPSun City Aviation LLC · Davie, FLBuilt 1999 · S/N 172S8267N344YUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 30056N344ZGlobal Pilot Inc · Wilmington, DES/N CD-231N34500Miller Judy Carole · No Palm Beach, FLBuilt 1972 · S/N 17701843
Back to AD 2007-04-19 R1