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.

N3310PLopes Gaston A · Dallas, TXBuilt 1973 · S/N 28R-7435121N3310RSeitz Martin V · Brookfield, WIBuilt 1967 · S/N 18258610N3310WBig Wing Energy LLC · Decatur, ARBuilt 1965 · S/N 32-148N3310YRegistration Pending · Fayetteville, ARRegistration pendingS/N 18254310N33110Grandview Aviation LLC · Bethel Park, PAS/N 28R-7535122N3311DPendergrass Joseph M · Wasilla, AKBuilt 1955 · S/N 32109N3311KBartholomew Donald B · Gardnerville, NVBuilt 1946 · S/N 1304N3311RView From Above Inc · Columbia, CABuilt 1967 · S/N 18258611N3311SExperimental Aircraft Association Inc · Oshkosh, WIBuilt 1969 · S/N 21059111N3311TSchulze Tom L · Smithville, MOBuilt 1967 · S/N 17700611N3311UBeck Gary · Albuquerque, NMBuilt 1963 · S/N 18254711N3311YChavez Rafael J · Santa Fe, NMBuilt 1962 · S/N 18254311N33121Civil Air Patrol Flying Association Inc · Branford, CTBuilt 1975 · S/N 28-7505124N33123Maccorkle Leon · Round Pond, MEBuilt 1975 · S/N 28R-7535123N33124Meyer Robert Dean Jr · California, MDBuilt 1975 · S/N 28-7510039N33128Flora Airport Authority · Flora, ILBuilt 1975 · S/N 28-7505125N33129Cloud 9 Flying Club Inc · Cedar Rapids, IABuilt 1975 · S/N 28R-7535124N3312FWill Robert J · Fall City, WABuilt 1966 · S/N 18257312N3312RParish Mark · Earth, TXBuilt 1967 · S/N 18258612N3312SBas Part Sales LLC · Greeley, COBuilt 1969 · S/N 21059112N3312URoberts Air Inc · Goodwin, ARBuilt 1963 · S/N 18254712N3312WMcmurray Michael J · Killeen, TXBuilt 1965 · S/N 32-150N33138Ables John M · Tehachapi, CABuilt 1975 · S/N 28-7525161N33139Hallert Benjamin F · Springfield, ORBuilt 1975 · S/N 28-7515320N3313ULayton Robert H · Seminole, TXBuilt 1963 · S/N 18254713N3313XBowman Cody · Brooklyn, MIBuilt 1967 · S/N 310L-0163N3313YCosta Flying Service Inc · Painted Post, NYS/N 18254313N33142Cogan Christopher · Warner Robins, GABuilt 1975 · S/N 28R-7535126N33143Bascom Jon A Trustee · Tega Cay, SCBuilt 1975 · S/N 32-7500015N33147Johann Austin J · Richland Center, WIS/N 28-7525163N33148Hitchcock Lonnie G · Sparta, TNBuilt 1975 · S/N 28-7515322N33149Great Lakes Air Ventures LLC · Mason, MIBuilt 1975 · S/N 28-7515323N3314EEnglund Frances L · Fairport, NYBuilt 1978 · S/N 17271500N3314SN3314s LLC · Oklahoma City, OKBuilt 1998 · S/N 18280236N3314YSimas Filomeno M · Grover Beach, CABuilt 1962 · S/N 18254314N33150Iowa County Flying Club Inc · Mineral Point, WIBuilt 1975 · S/N 28-7505127N33151Thayer Victoria · Ontario, CABuilt 1975 · S/N 28R-7535127N33153Pathfinder Ff LLC · Dover, DES/N 28-7510040N33158Mc Aviation LLC · Paducah, KYBuilt 1975 · S/N 28-7525164N3315AG A Davis LLC · Las Vegas, NVS/N TC-1355N3315EBas Part Sales LLC · Greeley, COS/N 17271501N3315FSabbe Bros Flying Service Inc · Maddock, NDFirst renewal noticeBuilt 1966 · S/N 18257315N3315QTcf Ventures LLC · Wilmington, DEBuilt 1966 · S/N 320D0115N3315RTriple X Construction Inc · Camp Verde, AZBuilt 1967 · S/N 18258615N3315TLovelady William K · Grapevine, TXBuilt 1967 · S/N 17700615N3315XElberg Paul · Aventura, FLBuilt 1967 · S/N 310L0165N33161Fca Flight Training LLC · Washington C H, OHS/N 28-7525165N33169Good James R H · Nevada City, CABuilt 1975 · S/N 28-7515326N3316PCrew Sourcing Inc · Wilmington, DEBuilt 1958 · S/N 23-1267N3316QPerson Michael · West Chester, PABuilt 1966 · S/N 320D0116
Back to AD 2007-04-19 R1