OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,408

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.

N102TCMason Brian L · Eagle River, AKS/N 18-7909038N102VWVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1957 · S/N 18-5806N102WCDac 2020 Inc · Skaneateles, NYBuilt 1978 · S/N 340A0443N102WPGarcia Randy S · Montebello, CABuilt 1991 · S/N S1572N102XRidley Benjamin · Jamesville, NYBuilt 1966 · S/N 310L-0034N10305Blunt Samuel N · Summerville, SCBuilt 1975 · S/N 17702319N1030RThomas Leasing Enterprise LLC · Troy, MIBuilt 2001 · S/N 29-0278N1030WChalupa Air LLC · Dover, DES/N D-9452N1030ZLenhart Thomas E · Barnesville, GABuilt 1997 · S/N 23041CN10319Battle Creek Aero Club Inc · Kalamazoo, MIBuilt 1957 · S/N BG-318N1031VIntelinair Geospatial LLC · Indianapolis, INBuilt 1974 · S/N U20602409N1031WBilco Air LLC · Danville, ILBuilt 1973 · S/N E-403N10322Skyview Resources LLC · Holland, MIBuilt 1957 · S/N BG-322N10329Lissow William M · New Port Richey, FLS/N 22018CN1032JKornegay Kenneth D · Roanoke, VABuilt 1973 · S/N 32N1032SThurber Matthew Calbraith · Vancouver, WABuilt 1980 · S/N 144-HN1032WOhlinger Mark A · Copley, OHBuilt 1973 · S/N D-9454N1032ZHoffman Curtis A · Marlborough, MABuilt 2003 · S/N 290309N10339Yarbro Floyd A · Kenton, TNBuilt 1997 · S/N 21022CN1033AAtlas Aviation Tampa Inc · Tampa, FLBuilt 2005 · S/N 17281238N1033CHuson Lee E · Port Townsend, WABuilt 1997 · S/N 25012CN1033PProfessional Pilots Inc · Lowell, INBuilt 1954 · S/N 23-35N1033QKuhn Marcus J · Madison, WIBuilt 2003 · S/N 29-0310N1033WPunci Aviation II LLC · Port Washington, WIS/N D-9455N1033XHorizon Enterprises LLC · Kalispel, MTBuilt 1975 · S/N 28-7515376N1033YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 172S10598N1034XBlasa Randy · Bowling Green, FLS/N 28-7505198N1035EJobe Ronald G · Sedalia, MOBuilt 1977 · S/N 983-77N1035NHiggins Michael S · Palatine, ILBuilt 2003 · S/N 29-0305N1035XSocal Blue Side Up LLC · Anaheim, CABuilt 1975 · S/N 28R-7535222N10368S-A Clark Aviation LLC · Fort Smith, ARBuilt 2002 · S/N 29-0286N1036JPremier Jets Inc · Hillsboro, ORS/N 36N1036MMangon Aircraft Inc · Petaluma, CABuilt 2007 · S/N 172S10599N1036NKovaleski Thomas J · Chugiak, AKBuilt 1997 · S/N 23035CN1036QKelley Michael · Bellingham, MABuilt 1977 · S/N 28-7716079N1036RYork Aviation LLC · Asheboro, NCBuilt 2003 · S/N 29-0302N1036TSlaughter Terry D · Perryton, TXBuilt 1976 · S/N E-928N10375Tactical Turtle LLC · Ortanna, PAS/N 67-18376N1037BSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1957 · S/N D-5311N1037JTate Andrew E · Chapel Hill, NCBuilt 1973 · S/N 37N1037TJohnson Shem E · Bonners Ferry, IDBuilt 1972 · S/N 18260859N1037VPulse Jeremy D · Moore, MTBuilt 1968 · S/N 18051989N1038EFueston Vernon A · Montague, CABuilt 1977 · S/N 971-77N1038FPetrick Dan A · Punta Gorda, FLBuilt 1969 · S/N 28-25552N1038JLandgraf Robert J · Sussex, WIBuilt 1973 · S/N 118N1038NSome Beech LLC · Bolivar, MOS/N 85-0360N1039A39a LLC · Sioux Falls, SDS/N D-9009N1039GFountain Keith E · Jacksonville, NCBuilt 1979 · S/N 21063174N1039JN1039j LLC · Casa Grande, AZBuilt 1973 · S/N 101N1039MManly James H · Reno, NVBuilt 1998 · S/N 513
Back to AD 2007-04-19 R1