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.

N489CYW Morrison Consulting Group Inc · Aliso Viejo, CABuilt 1973 · S/N 28-7310121N489ERMenefee Scott A · Los Banos, CABuilt 1978 · S/N 17272083N489GBNorthland Hangars LLC · Anchorage, AKBuilt 2015 · S/N 13815N489HPHigh Performance Aircraft LLC · El Cajon, CABuilt 1989 · S/N CE-1343N489JOrr Matthew W · Kirkland, WAS/N 265N489JEChambless Mardre F II · Panama City, FLBuilt 2004 · S/N 90508N489LARed Baron LLC · Middletown, DES/N 47007TN489MHendrix Danny J · Aledo, TXBuilt 1960 · S/N D-6505N489PWsi Southwest Inc · Cliff, NMBuilt 1965 · S/N 28-21083N489RSViage LLC · Boston, MABuilt 2004 · S/N 40.379N489RVBoyter Wayne · Winston, ORBuilt 2008 · S/N 21275N489TWehinger Christopher L · Hebron, OHBuilt 1961 · S/N CD-312N489TJUnknown Media LLC · Cape Canaveral, FLS/N 3024N48ALHutchinson Scott · Missouri City, TXBuilt 1976 · S/N 21061658N48AMGwc Air LLC · Madison, ALBuilt 1980 · S/N 414A0609N48ARGacey Inc Trustee · Wilmington, DEBuilt 1966 · S/N 30-1328N48ASTheunissen Wilhelmus H · Oxnard, CABuilt 1998 · S/N 6007N48BGWhitfill Mark J · Crockett, TXBuilt 1978 · S/N 17271064N48BKKrebs Brian G · Hartland, WIBuilt 2012 · S/N 82136N48BRField Christopher R · Kingston, TNBuilt 2009 · S/N 90951N48BTMalone William · Mount Nebo, WVBuilt 1993 · S/N 5276N48BWBroadmoor Bed And Breakfast LLC · Colorado Springs, COBuilt 1975 · S/N CE-582N48CCC Baron LLC · Lafayette, LAFirst renewal noticeBuilt 1981 · S/N TH-1277N48CDSky Helicopters Inc · Desoto, TXBuilt 2016 · S/N 30006N48CEEssential Aviation Llcregistered · Hickory, KYBuilt 1958 · S/N TD-163N48CLSharp Wade L · Asheville, NCS/N 21184N48CMR Stephen Smith Inc · Wichita, KSS/N TE-985N48DFFuhrman Dennis M Trustee · Independence, ORBuilt 2020 · S/N 41653N48DJVan Iwarden Tracy D · Vacaville, CAS/N 65-12684N48DXSomers Andrew · El Paso, TXBuilt 2003 · S/N 386N48EFVista Air Inc · Pacoima, CABuilt 2004 · S/N 172S9629N48ELRegistration Pending · Livermore, CARegistration pendingBuilt 2004 · S/N 1363N48ERChess Group LLC · Minden, LABuilt 1978 · S/N AA5B0906N48EWKucel Richard S · Dallas, TXFirst renewal noticeBuilt 1992 · S/N 5249N48FCSoarmates Inc · Missoula, MTFirst renewal noticeBuilt 1968 · S/N U206-1099N48FFWingsleasing LLC · Wichita, KSBuilt 2022 · S/N 172S12875N48FHG-Stf LLC · Midland, TXBuilt 1979 · S/N R18201018N48GHYellowstone Aviation Inc · Jackson, WYBuilt 1999 · S/N 2049N48HAFiack Daniel P · Sun Valley, IDBuilt 1953 · S/N 22-975N48HGJahn Glenn R · Torrance, CABuilt 2005 · S/N 70449N48HTTurner Robert E · Castro Valley, CABuilt 2011 · S/N 40745N48HYStruble Anne D · Springville, UTBuilt 2002 · S/N 2196N48JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1975 · S/N 17265312N48JGWulvik Frederik M · Wasilla, AKBuilt 1974 · S/N 18502391N48JHFlying O Consulting LLC · Hammon, OKBuilt 1971 · S/N E-297N48JJTotten James C · Newark, NJBuilt 1979 · S/N GA7-0110N48JKKeahey Britt · Saint Joseph, LABuilt 1972 · S/N 17260693N48JLPfister Gregory S · Naples, FLBuilt 1971 · S/N CD-1256N48JWLee William L · Jonesborough, TNBuilt 1989 · S/N 2N48KBRydberg Lawrence · Albuquerque, NMBuilt 1998 · S/N 26
Back to AD 2007-04-19 R1