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.

N3330MMaine Instrument Flight · Augusta, MEBuilt 1979 · S/N TH-1031N3330RJph Incorporated · Kokomo, INBuilt 1970 · S/N 28-5659N3330UWolford Alyson · Bonney Lake, WABuilt 1963 · S/N 18254730N3330XMylin LLC · Havre De Grace, MDS/N 310L-0180N3330YTighe Joseph E · Kingsland, TXBuilt 1962 · S/N 18254330N33313Larson Laurinda P · Hubert, NCBuilt 1975 · S/N 28-7525170N33318Sudweeks Will · Overton, TXS/N 28-7525172N33319Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1975 · S/N 28-7515328N3331DKramer Donald J · Buffalo, MNBuilt 1955 · S/N 32129N3331QEvangelista Ronald · Castle Rock, COBuilt 1977 · S/N 28-7716148N3331REpik Industrial LLC · Terre Haute, INBuilt 1969 · S/N 28-5661N3332Degaynor Gregory S · Zeeland, MIBuilt 1971 · S/N 25N33321Lauher Donna · Wimberley, TXBuilt 1975 · S/N 28-7505133N33324Central Nebraska Spinal Surgery Center Pc · Kearney, NEBuilt 1975 · S/N 32-7500018N3332BAirkrapf LLC · Clearwater, FLBuilt 1997 · S/N E-3140N3332SFluckey Gary T · Homer, AKS/N 18502274N3332TWilliams Darryl L · Medina, OHS/N 17700632N3332UMing Greg A · Guymon, OKBuilt 1963 · S/N 18254732N3332ZWeisenburger Adam A · Seeley Lake, MTS/N 22-7269N33338Graham Mark · Fort Smith, ARBuilt 1975 · S/N 28-7525174N3333MFun Tickets LLC · Manchester, MEBuilt 1981 · S/N 340A1229N3333RBuck Joseph M · Copper Center, AKBuilt 1960 · S/N 18-7565N3333WRegistered aircraftBuilt 1967 · S/N 28-22874N3333YDeville Charles D · Clinton, LABuilt 1962 · S/N 18254333N33348Air Venture Inc · Hagerstown, MDBuilt 1975 · S/N 28R-7535136N33349Stroud Jerry · Hope, ARBuilt 1975 · S/N 28R-7535137N3334EJarmer Ryan F Trustee · San Diego, CABuilt 1978 · S/N 17271509N3334PM & M Aero LLC · Wilmington, DEBuilt 1978 · S/N 32-7840080N3334QViking Aerial Photography LLC · Zionsville, INBuilt 1977 · S/N 28-7790449N3334TBaumann Keith A · Fairfield, ILBuilt 1967 · S/N 17700634N3334YHarless Richard K · Battle Mountain, NVBuilt 1962 · S/N 18254334N3335BHutsell James M · Miamisburg, OHBuilt 1954 · S/N 22-2150N3335DWilson Zane D · Fairbanks, AKBuilt 1955 · S/N 32133N3335FSocorro Meraz · El Paso, TXBuilt 1966 · S/N 18257335N3335PHill Silas W Trustee · Delta Junction, AKBuilt 1958 · S/N 18-6770N3335RJones Wesley M Jr · Hollywood, SCBuilt 1969 · S/N 28-5662N3335UFogle Kenneth J · Chagrin Falls, OHBuilt 1963 · S/N 18254735N3335XPfeiffer Engineering LLC · Boonville, MOBuilt 1967 · S/N 310L-0185N33361Petit Raymond T Trustee · Westerville, OHBuilt 1975 · S/N 28R-7535087N33363Mcdonald Joseph W · Olympia, WABuilt 1975 · S/N 28-7515312N33367Smtm Holdings Inc · Wilmington, DEBuilt 1975 · S/N 28-7505136N3336MStevens Matthew Joel · Millersburg, MIBuilt 1947 · S/N 12-2194N3336SVancil Todd · Justin, TXBuilt 1969 · S/N 21059136N3336TBirch Point Ventures LLC · Virginia, MNS/N 18051494N3336WBuck Brothers · Joliet, ILBuilt 1965 · S/N 32-173N3336ZCedar Mark P · Cherokee, IABuilt 1960 · S/N 22-7276N3337Chay James M · Kent, WABuilt 1978 · S/N P3370316N33371Galle David R Trustee · Manchester, NHBuilt 1975 · S/N 28-7505137N33372N33372 LLC · New Bern, NCBuilt 1975 · S/N 28R-7535139N33376Price Gregory D · Frankfort, ILBuilt 1975 · S/N 28-7515333
Back to AD 2007-04-19 R1