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.

N368CMKraemer Jeffrey J · Cold Spring, MNBuilt 2005 · S/N 29-0368N368CPWilliams Truman V · Robbinsville, NCBuilt 1980 · S/N R18201580N368ESMindy Limited LLC · Muscatine, IABuilt 1997 · S/N 17280022N368FSFrederick Investment Corp · Fort Lauderdale, FLBuilt 2006 · S/N 23097CN368HPHigh Performance Aircraft Inc · El Cajon, CABuilt 1981 · S/N E-1833N368HYEngler Eric DBA · Cass City, MIBuilt 2006 · S/N 2363N368JEJones Enterprises · Nacogdoches, TXBuilt 1980 · S/N TH-1145N368JHUrsine L Attitudes Ltd · Richland, WABuilt 1981 · S/N E-1920N368MState Of Montana · Helena, MTBuilt 1999 · S/N 18280598N368MEWbl Air LLC · Minneapolis, MNBuilt 2000 · S/N 18280859N368MKNorth Star Aviation Inc · Mankato, MNBuilt 2024 · S/N 2881776N368MSSilvestri Mark J · Warwick, NYBuilt 2006 · S/N 11343N368POfferaire Inc · Lebanon, NJBuilt 1995 · S/N E-2942N368RTBaldhill Flying Partners Llp · Binford, NDBuilt 1978 · S/N 28-7890531N368SAIrish Sidney D · Roosevelt, NYBuilt 1968 · S/N 28R-30919N368TMStriker LLC · Lewes, DEBuilt 2026 · S/N 14989N368VKranz Daniel · Hastings, MNBuilt 1968 · S/N E-21N368ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881646N36900Bas Part Sales LLC · Greeley, COBuilt 1980 · S/N E-1739N36908Williams D Eric · Palm Springs, FLBuilt 1980 · S/N 402C0313N3690AJohnson Mandley O Jr · Bismarck, NDBuilt 1953 · S/N 18-3038N3690DR B M Corporation · Cropwell, ALBuilt 1980 · S/N TJ-306N3690KCrouch James Doyle Jr Trustee · Germantown, TNBuilt 1967 · S/N 28-23689N3690NDetraglia Michael C · Canandaigua, NYBuilt 1980 · S/N EA-123N3690REagle Aero LLC · Clermont, FLBuilt 1970 · S/N 28-5715N36911Hyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0314N3691AClark Clyde E · Naknek, AKBuilt 1953 · S/N 18-3039N3691NGalvan Peter R · Slidell, LAS/N 680038N3691QKempf David V · San Tan Valley, AZS/N MA-276N3691YHunt Lynn C Trustee · Windsor, CAS/N 21058191N3691ZRiedesel Ralph L · Paton, IABuilt 1960 · S/N 18-7426N3692ABva Bonanza LLC · Keizer, ORBuilt 1969 · S/N D-9091N3692CDevil Dusters Inc · Artesia, NMS/N 31191N3692UPineview Ac Sales LLC · Bedford, WYBuilt 1963 · S/N 18255092N3692WMckimson Lance D · Wasilla, AKBuilt 1966 · S/N 32-603N3692ZRegistered aircraftBuilt 1960 · S/N 18-7427N36939Holtzen Farms Inc · Jerome, IDBuilt 1980 · S/N EA-129N3693AC And F Enterprise L L C · Milford, MIBuilt 1964 · S/N D-7384N3693RA Parrottes View In Flight LLC · Wilmington, DES/N 28-5213N3694LRegistered aircraftBuilt 1980 · S/N TH-1176N3694NWheeler Kevin J · Concord, CABuilt 1967 · S/N 680039N3694RSippel Paula M · Webster, NYBuilt 1971 · S/N 28-7105135N3694UPara Tactics LLC · Shelton, WAFirst renewal noticeBuilt 1963 · S/N 18255094N3694YScott Dale D · Alliance, OHBuilt 1963 · S/N 21058194N36958N36zz LLC · Parkland, FLBuilt 1980 · S/N EA-137N3695ADehart T James Trustee · Kalama, WABuilt 1954 · S/N 18-3044N3695COrton Dennis · Mead, COBuilt 1978 · S/N R18200312N3695LBg Aviation LLC · Waukesha, WIBuilt 1980 · S/N TC-2353N3695MTreanor James J · Wolcott, CTBuilt 1978 · S/N 28-7890323N3695NWalton Jerry Prince Jr · Monticello, FLBuilt 1980 · S/N TH-1192
Back to AD 2007-04-19 R1