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.

N3636YMorales Peter · Lake Worth, FLBuilt 1963 · S/N 21058136N3637CThree Seven Charlie LLC · Camp Hill, PABuilt 1978 · S/N R18200288N3637PBlazek Troy L · Cottage Grove, MNBuilt 1955 · S/N 22-3374N3637RGelinger Gary · Cape Carteret, NCBuilt 1970 · S/N 28-5732N3637WStruck Dennis L · Spirit Lake, IABuilt 1966 · S/N 32-539N3637ZFord Kristy M · Marianna, FLBuilt 1960 · S/N 22-7532N36382Pallaziol Delia N · Vista, CABuilt 1973 · S/N 389-73N36384Lisa Rocco J · Elkhart, INBuilt 1978 · S/N 28R-7837277N36387Hlavin Mark S Trustee · Lakewood Ranch, FLBuilt 1981 · S/N 6008778161249N3638HQuantie Harold G · Locust Grove, OKS/N 20-1256N3638PSorrell Byron D · Warren, MIBuilt 1955 · S/N 22-3389N3638QWinder Keven S · Castle Rock, COBuilt 1967 · S/N MB-251N3638RDukeman James C · Apex, NCBuilt 1970 · S/N 28-5735N3638WCherokee Six LLC · Williamson, GABuilt 1966 · S/N 32-540N36393Meriden Aviation Center LLC · Meriden, CTS/N 28-7816633N36395Brittle Aviation LLC · Chapel Hill, NCBuilt 1978 · S/N 28-7816634N3639DOlah Michael J DBA · Mazomanie, WIBuilt 1956 · S/N 35339N3639HBeatty Earl IV · Gambrills, MDBuilt 1978 · S/N 20-1257N3639PJoseph Patrick S · Saint Charles, MOBuilt 1955 · S/N 22-3390N3639UWaltz Elizabeth · Grapevine, TXBuilt 1963 · S/N 18255039N3639WYoungpeter David L · Spencerville, OHBuilt 1966 · S/N 32-542N3639YMurphys Flying Service LLC · Quitman, GABuilt 1963 · S/N 21058139N3639ZStahl Calvin D · Auburn, WABuilt 1960 · S/N 22-7534N363ACAig Aeronautics LLC · Guaynabo, PRBuilt 2000 · S/N 3246161N363BShoal Properties LLC · Bokeelia, FLBuilt 1957 · S/N D-5087N363BLElizabeth City State University · Elizabeth City, NCBuilt 2004 · S/N 172S9741N363CKAviator Air Operations LLC · Grand Prairie, TXBuilt 2004 · S/N 172S9634N363CPBarr Air Patrol LLC · Mesquite, TXBuilt 2000 · S/N 172S8382N363CS3tr Aviation LLC · Longview, TXBuilt 2022 · S/N 18283163N363DSDonkers Dave · Nerstrand, MNBuilt 2003 · S/N 40.303N363FSMarlu Enterprises Inc · Foristell, MOBuilt 1999 · S/N 23049CN363GCPorter David R · Dayton, OHBuilt 1993 · S/N 363N363JVRead Andrew R · Milwaukee, WIBuilt 1976 · S/N 18502991N363KRegistered aircraftBuilt 2018 · S/N 172S12195N363KBTriple F LLC · Dixon, ILBuilt 1996 · S/N E-3000N363MBCohen Greg · Gaithersburg, MDBuilt 1997 · S/N E-3143N363MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881653N363RMankind Aviation LLC · Cincinnati, OHBuilt 1968 · S/N E-97N363RJJordan Robert A · Avon Park, FLBuilt 2003 · S/N 363N363RMMash Kity J LLC · Grand Rapids, MIBuilt 1974 · S/N 310R0046N363RSOgden Laurence B · Weaverville, NCBuilt 1983 · S/N E3B-360N363RVRoberts David · Albuquerque, NMBuilt 2010 · S/N 60388N363SCOcm Aviation LLC · Buckeye, AZBuilt 2004 · S/N 1209N363SKKamasano LLC · Highland, CABuilt 2011 · S/N 2164N363SPOrange County Flight Center Inc · Santa Ana, CABuilt 2001 · S/N 172S8781N363T1800sky LLC · Henderson, KYBuilt 1963 · S/N TC-416N363TGGautier Thomas N III · Altadena, CABuilt 2017 · S/N 40363N363WDFas Aviation LLC · Southlake, TXBuilt 2023 · S/N 14656N363ZN363z Flyers LLC · Lenexa, KSBuilt 1960 · S/N D-6526N36400Vlietstra Steven J · Hatley, WIBuilt 1978 · S/N 28-7890511
Back to AD 2007-04-19 R1