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.

N4917NHanging On The Prop LLC · San Tan Valley, AZBuilt 1979 · S/N 18267454N4918CJetblack Ventures LLC · Bakersfield, CABuilt 2005 · S/N 1264N4918FBarnes Charles G · Louisville, KYBuilt 1976 · S/N 28-7715081N4918JWoolley Charles K · Clarksville, TNBuilt 1968 · S/N 28R-30638N4918LAthene Solutions LLC · Coral Springs, FLBuilt 1967 · S/N 28-4283N4918QNauta Larry D · Soldotna, AKBuilt 1978 · S/N 18503575N4918SSilverado Sales Inc · Orem, UTBuilt 1980 · S/N R18201457N4918UMission Aviation Fellowship · Nampa, IDBuilt 1979 · S/N U20605160N4918YGrathwohl Air LLC · Bloomfield Hills, MIBuilt 1980 · S/N 21064046N49192Torii Aviation LLC · Naperville, ILBuilt 1974 · S/N 28-7410025N4919DDewitz Mark A · Good Thunder, MNBuilt 1958 · S/N 51019N4919FTice Denzil · Farmville, VABuilt 1979 · S/N 17273102N4919LCroft Jeffrey W · Tennessee Colony, TXBuilt 1967 · S/N 28-4284N4919NKoffeman Edward · Midlothian, TXBuilt 1979 · S/N 18267455N491ACEw Pegasus LLC · Walnut Creek, CAS/N 21063673N491AFMeyer Terry L · Wayne, NEBuilt 1968 · S/N 18258754N491BAirside Kc LLC · Riverside, MOBuilt 1974 · S/N TE-1012N491CCBarbee Johnny Lee · Fort Stockton, TXBuilt 1971 · S/N 18260654N491CMMottinger Casey P · Elizabeth, COBuilt 2012 · S/N 82107N491DKey City Fliers · Maquoketa, IABuilt 1973 · S/N 28-7325632N491EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12259N491ETKennebeck Ronald C · Johnston, IABuilt 1968 · S/N 28-24880N491FLWashington Fliers Inc · Pantego, NCBuilt 1971 · S/N 28-7125304N491GShelton Christopher O · Aubrey, TXBuilt 1968 · S/N 28-25022N491JPGuy Jeffrey · Centerburg, OHS/N 491N491MABelle Casa Sport LLC · Tarpon Springs, FLBuilt 2004 · S/N 957-2004N491NDChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 4496236N491PDAir Ventures Awaits LLC · Middletown, DEBuilt 1974 · S/N M-1574N491SGryphon Ventures LLC · Apollo Beach, FLBuilt 2003 · S/N 0491N491SAShier Aviation Corp DBA · San Diego, CABuilt 2009 · S/N 12831N491SFSnohomish Flying Service Inc · Snohomish, WABuilt 2003 · S/N 172S9565N491SGGott Shelby L · Tucson, AZBuilt 2008 · S/N 80491N491SPLittle Rock Lsa Leasing And Rental LLC · Searcy, ARBuilt 1998 · S/N 172S8032N491WMRenlim Aviation LLC · Brookhaven, GABuilt 1985 · S/N TJ-491N491WSDhs Operations LLC · Wilmington, DEBuilt 1999 · S/N 172S8305N4920ABerry Thomas R · Anchorage, AKBuilt 1956 · S/N 32317N4920GEye Candy Aviation LLC · Jacksonville, FLBuilt 1979 · S/N 17273467N4920LLvc Air LLC · Allen, TXBuilt 1967 · S/N 28-4285N4920PDetert Bradley · Valparaiso, INBuilt 1962 · S/N 27-510N4920SExecutive Flyers Inc · Sacramento, CAS/N R18201459N4921AHogan William J · Libby, MTBuilt 1956 · S/N 32318N4921DMills Air Service Inc · Marstons Mills, MABuilt 1958 · S/N 51021N4921FCa Aviation 172 LLC · Santa Barbara, CAS/N U206-0621N4921JHerdrich Sean D · Manchester, IABuilt 1968 · S/N 28R-30642N4921LBarrett Howard L · Austinville, VABuilt 1967 · S/N 28-4286N4921PAndre David E · San Jose, CABuilt 1962 · S/N 27-511N4921RBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 18802438TN4921VFrumkin Mark Steven · Pittsburgh, PABuilt 1980 · S/N 172RG0416N4922DD Gordon Aviation Inc · La Jolla, CABuilt 1979 · S/N 17272398N4922GBishop Air LLC · Elk Grove, CABuilt 1979 · S/N 17273469
Back to AD 2007-04-19 R1