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.

N331MKStardust Aviation LLC · Farmingdale, NYBuilt 2001 · S/N 2843477N331MSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 18282021N331NTCrowley E Ned · Londonderry, NHS/N N.C.1N331PEnglish Barton C · Liberty Corner, NJBuilt 2007 · S/N 40143N331PAHale Enterprises Inc · Carbondale, ILBuilt 2002 · S/N 2843514N331PHAppel Raymond Lee · Incline Village, NVBuilt 1977 · S/N 28-7710045N331RDHiggins Roland · Solon Springs, WIBuilt 2005 · S/N 25720N331RHWhite Wing Aviation LLC · Shreveport, LABuilt 1977 · S/N CE-691N331RPRaritan Valley Flying School · Princeton, NJS/N 172S9863N331SPReinfeldt Phillip R · Burnsville, MNS/N 18268441N331VRRoof Jerry G · Centennial, COBuilt 1991 · S/N 509N331WTillman Nickolas R · Piggott, ARBuilt 1972 · S/N 287225543N331WBAb Aviation LLC · Ashland, OHBuilt 1969 · S/N 28-5401N3320DPara Tactics LLC · Shelton, WAS/N 32118N3320FPoock Jerry D · Spencer, IABuilt 1966 · S/N 18257320N3320ZHolton Mark · Lebanon, MOBuilt 1960 · S/N 22-7255N33216Avarts LLC · New Castle, DES/N U20602676N3321CAviation Management II LLC · Des Moines, IAS/N E-1261N3321FOwl Aviation LLC · Kingsport, TNBuilt 1966 · S/N 18257321N3321LN3321l LLC · Dacula, GAS/N 3321N3321MMaxray Aviation LLC · Ashland, OHBuilt 1978 · S/N 310R1343N3321RGray Kerry L · Granbury, TXBuilt 1967 · S/N 18258621N3321TWilks Donald Leon · Flat Rock, ALBuilt 1967 · S/N 17700621N3321XPatton Aviation LLC · Billings, MTS/N 310L-0171N3322DObrien Aviation LLC · Moreno Valley, CABuilt 1955 · S/N 32120N3322FCrystalline Entity · Los Angeles, CABuilt 1966 · S/N 18257322N3322GLone Star Flight Museum · Houston, TXBuilt 1970 · S/N 39-10N3322KHamilton Roger A Trustee · Pisgah Forest, NCBuilt 1975 · S/N AA5B-0046N3322UPrecision Design Inc · Wilimington, DEBuilt 1963 · S/N 18254722N3322WWilson Devin · Star, IDBuilt 1965 · S/N 32-156N3322XAllgood Michael K · Saint Augustine, FLBuilt 1974 · S/N 310Q1030N3322YFostair Inc · Ovid, NYS/N 18254322N3323DPrince Christopher E · Anchorage, AKBuilt 1955 · S/N 32121N3323FFly The Dream LLC · Sun Prairie, WIBuilt 1966 · S/N 18257323N3323MTalbot Larry · Bradenton, FLBuilt 1977 · S/N 28-7890296N3323RD&J Air Adventures Inc · Koloa, HIBuilt 1967 · S/N 18258623N3323TDeese James K Jr · Charlotte, NCS/N 17700623N3323YMiellerie LLC · Bridgeport, TXBuilt 1962 · S/N 18254323N33247R House Leasing LLC · Stormville, NYBuilt 1975 · S/N U20602692N3324UHaer Welton · Craig, MOBuilt 1963 · S/N 18254724N3324WThompson Mark D · West Chicago, ILBuilt 1965 · S/N 32-158N3324YVoge Michael · Chino Hills, CABuilt 1962 · S/N 18254324N3325QWinrick LLC · Flagstaff, AZS/N 320D0125N3325RDresick Farms Inc · Huron, CABuilt 1968 · S/N 18258625N3325UWeber Donald E · Saint David, AZS/N 18254725N3325WGuzman Ronald Leonard · Salinas, CABuilt 1965 · S/N 32-160N3326FRegistered aircraftBuilt 1966 · S/N 18257326N3326MMcray Brett H · Sugar Land, TXBuilt 1977 · S/N 28R-7837111N3326PDean Marshall H · El Paso, TXBuilt 1958 · S/N 23-1277N3326RAnderson Patrick Alan · Ripley, WVS/N 18258626
Back to AD 2007-04-19 R1