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.

N507NANasa Langley Research Center · Hampton, VABuilt 2000 · S/N 40008N507PHocker Matthew Tutt · LondonBuilt 2001 · S/N 18281008N507RGMccurdy Paul R · North Falmouth, MABuilt 1995 · S/N 2507N507RHJones Douglas H · Prather, CABuilt 1993 · S/N 20200N507SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881421N507SDKnapp Jason D · Schenevus, NYBuilt 1958 · S/N 34950N507TFairchild Property Management LLC · Monterey, CABuilt 1968 · S/N TC-1111N507THLeyva Maria · Edgewater, FLBuilt 1971 · S/N 34-7250037N5080CCommerical Ice & Refrigeration LLC · Marlton, NJBuilt 1978 · S/N 310R1506N5080DJohnson Kenneth J · Red Bluff, CAS/N 51180N5080EAdams Kenneth C · Neosho, WIBuilt 1958 · S/N 50380N5080RRodriguez Roberto F · Tampa, FLBuilt 2001 · S/N E-3386N5080WMatzke Kevin T · Gilbert, AZBuilt 1961 · S/N 28-89N5080XOber John A · Candor, NYBuilt 1968 · S/N 143N5080YOptic Air LLC · Maurice, IABuilt 1981 · S/N 18267875N5081EGolden Alan · Wilmette, ILBuilt 2001 · S/N E-3401N5081QAsani Ilirian L · Alton, ILBuilt 1968 · S/N 310N-0181N5081SDream Factory Aviation Inc · Henderson, NVBuilt 1971 · S/N 28R-7135081N5081UKiloecho Aeronautics LLC · Tucson, AZBuilt 1971 · S/N 17259673N5081VWalker Gregory S · Gypsum, COBuilt 1977 · S/N VAC-70-77N5081YDoumis Joy S · Marathon, FLBuilt 1962 · S/N 27-2099N50822Nyhus Sharon L · Harvey, NDBuilt 1980 · S/N 17274221N50826Bristol Bay Capital LLC · Watkins, COS/N 17274222N5082DRegistered aircraftBuilt 1958 · S/N 51182N5082EWeaver M Thomas · Kalispell, MTBuilt 1979 · S/N 18503928N5082GJala Tech Services LLC · Social Circle, GABuilt 1979 · S/N 17273531N5082PShaw Jeryl V · Arcata, CABuilt 1958 · S/N 24-88N5082RWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263320N5082VMorton John W · El Segundo, CABuilt 1977 · S/N VAC-71-77N5082WAmeeti Robert Keith Trustee · Newport Beach, CABuilt 2001 · S/N 172S8970N5082YTanner Greg · Bend, ORBuilt 1962 · S/N 27-2100N50838Ansee LLC · Seattle, WABuilt 1980 · S/N 17274224N5083CTsf Inc · Bristol, WIBuilt 1980 · S/N R18201555N5083JKrs Aerial Inc · Galloway, OHS/N 310R0203N5083KLoewen Wielhelm N · Presidio, TXBuilt 1980 · S/N 17273956N5083NN5083 LLC · San Diego, CABuilt 1979 · S/N 18267504N5083SRiser Air LLC · Stillwater, MNBuilt 1971 · S/N 28R-7135082N5083TClaar Brian · Spring, TXBuilt 1982 · S/N EA-287N5083VBarth Charles L · Pekin, ILBuilt 1977 · S/N VAC72-77N5083WJtc Investments LLC · Tyrone, GABuilt 1980 · S/N P21000635N5083XFlytails LLC · Pace, MSFirst renewal noticeBuilt 1968 · S/N 155N5084DArrow LLC · Pateros, WABuilt 1958 · S/N 51184N5084MFabrizio Timothy · Oswego, ILBuilt 1978 · S/N MC-571N5084RBenham Eric T · Las Vegas, NVBuilt 1974 · S/N 17263322N5084VAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2004 · S/N 0831N5084WShouse Robert G · Owasso, OKBuilt 1961 · S/N 28-93N50854Fulton Lanny G · Spartanburg, SCBuilt 1968 · S/N 15069600N50858Christiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 172S10894N5085DHawkes Brian R · Hamilton, MTBuilt 1958 · S/N 51185N5085KMartin Bach Aviation LLC · Cornelius, NCBuilt 1980 · S/N 17273957
Back to AD 2007-04-19 R1