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.

N5582YFliege Thomas D · Peoria, ILBuilt 1980 · S/N BF-1N55830Rudd Clark David · Sheboygan Falls, WIBuilt 1973 · S/N 28R-7335296N55837Mcqueen Bill · Turlock, CAS/N 28R-7335298N55838Hintenlang David · Archer, FLBuilt 1973 · S/N 28-7305435N55839David Gill · Marietta, GAS/N 28-7310133N5583DHanks Dustin Maxwell · Milton, FLBuilt 1957 · S/N D-5158N5583FAiken Pilot Training LLC · Johnston, SCBuilt 1968 · S/N 28-24916N5583J5150 Ventures LLC · Effingham, ILBuilt 1968 · S/N 32-1043N55840Walko Michael E · Scotch Plains, NJBuilt 1973 · S/N 28-7325551N55842Ansboro James C · Goshen, NYBuilt 1973 · S/N 28-7325502N55844Cozby Charles L · Wellsboro, PAS/N 28-7325503N5584DBenson Robert W III · Wichita Falls, TXBuilt 1957 · S/N D-5110N5584FGuiliano Anthony · Tobyhanna, PABuilt 1968 · S/N 28-24917N5584JDelano James B · Laverne, CABuilt 1968 · S/N 32-1044N5584PPinnell Roger D · Shell Knob, MOBuilt 1959 · S/N 24-648N5584QHurst Jonathan T · Seekonk, MABuilt 1964 · S/N 256N5584WDill Mark B · Amarillo, TXBuilt 1962 · S/N 28-658N55852Ingold Terry L · Albemarle, NCBuilt 1973 · S/N 28-7305484N55855Caspersen Lars · Bloomsburg, PAS/N 28R-7335301N5585FSouth Texas Air Force LLC · Mission, TXBuilt 1968 · S/N 28-24918N5585JPhb Aviation Inc · Melbourne Beach, FLBuilt 1968 · S/N 32-1027N5585KMacias Aviation LLC · Canadian, TXBuilt 1989 · S/N CE-1385N5585PBas Part Sales LLC · Greeley, COBuilt 1958 · S/N 24-649N5585QCoxwell James · Midlothian, TXBuilt 1965 · S/N 2981N5585WFoss Jason Steven · Cokato, MNBuilt 1962 · S/N 28-665N5585YBlacklock Beech Boys LLC · Langlois, ORS/N CE-1389N5586DOh Joseph K · Anaheim, CABuilt 1967 · S/N 28R-30116N5586USoisson Douglas M · Barnesville, GABuilt 1969 · S/N 28-26316N55870Legacy Aviation LLC · Tea, SDS/N 28-7305487N55871Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1959 · S/N 18-6409N55877N A Corp · Scappoose, ORS/N 34-7350255N55879Buchholtz Tony E · Greenville, OHBuilt 1973 · S/N 28-7325485N55880Wings Up LLC · Saint Augustine, FLBuilt 1973 · S/N 28-7325517N55881Phoenix Kingdom LLC · Washington, DCS/N 28-7325518N55884Mcgee Daniel J · Indianola, IABuilt 1973 · S/N 28-7305491N55885Massa Paul G · Windsor Locks, CTBuilt 1973 · S/N 28R-7335305N55888Wild Horse Aviation LLC · Tabor City, NCBuilt 1980 · S/N 7-0382N5588FRckr Aviation LLC · Chehalis, WABuilt 1968 · S/N 28-24921N5588PNorth Town Comanche LLC · North Las Vegas, NVBuilt 1959 · S/N 24-654N5588UMontgomery Richard E · Omaha, NEBuilt 1969 · S/N 28-26318N5588WBartz Nicole · Cleveland, MOBuilt 1962 · S/N 28-725N55890S & L Sports LLC · New Hampton, IABuilt 1973 · S/N 28-7305492N55899Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1973 · S/N 28-7325521N5589DForrester Dale E · Scotland, PABuilt 1957 · S/N D-5166N5589FTjl Aviation LLC · Atlanta, GABuilt 1968 · S/N 28-24922N5589PEggers Cindy S · Winnemucca, NVBuilt 1959 · S/N 24-655N5589UGq Aviation LLC · Cherry Hill, NJBuilt 1969 · S/N 28-26320N558AZHess Michael R · Alexandria, VAFirst renewal noticeBuilt 2004 · S/N 90399N558BTKeesling Roger L · Starkville, MSBuilt 1969 · S/N 310P0220N558CBFrancis Scott P · Montclair, VAS/N TC-1800
Back to AD 2007-04-19 R1