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.

N387JRThree Eight Seven Jr LLC · Sunray, TXBuilt 2001 · S/N E-3393N387JVBonura Rocco F Jr · Perkinston, MSS/N 24139N387LCCooper Gerald W · Kennewick, WABuilt 2000 · S/N 54821N387LRWoodruff Howard G · Goodyear, AZBuilt 2004 · S/N 0961N387MAAzul Services LLC · Bozeman, MTBuilt 1998 · S/N 17280387N387RCrossley Eber G · Farmington, NMBuilt 2004 · S/N EGC-01N387SPMsb Aviation LLC · Rockvale, TNBuilt 1999 · S/N 172S8284N387TBP5 Aviation LLC · Cumming, GABuilt 2008 · S/N 12574N387VBEnt Aviation LLC · Smithfield, VABuilt 2021 · S/N 14478N387WYSvp LLC · Missoula, MTBuilt 1977 · S/N 18265614N387XDowns Rodney A · Anchor Point, AKFirst renewal noticeBuilt 1976 · S/N 7024CN387ZLily Pad Aero LLC · Minneapolis, MNBuilt 1960 · S/N CD-273N38804H And R Aviation LLC · Jonesboro, ARBuilt 1977 · S/N 28-7790589N38809Somerset Air Service Inc · Bedminster, NJBuilt 1977 · S/N 28-7725250N3880CGreer Glenn M · Eugene, ORBuilt 1954 · S/N 31028N3880DWallace David L · Huntersville, NCBuilt 1957 · S/N 34580N3880QJ&J Hangars LLC · Newnan, GABuilt 1971 · S/N 17259980N3880TThoms Gregory S · Adkins, TXBuilt 1967 · S/N 28R-30206N3880WSpecialized Communications · Smithsburg, MDBuilt 1966 · S/N 32-826N3880YLake Country Aviation LLC · Milledgeville, GABuilt 1964 · S/N 21058380N38818Rogers Jason · Limerick, PABuilt 1977 · S/N 32R-7780475N3881XVincent Ricky M · Clinton, LABuilt 1967 · S/N 184N3881YNorton Tim C · Danville, VABuilt 1964 · S/N 21058381N3882GRanier Flight Service LLC · Friday Harbor, WABuilt 1967 · S/N U206-0882N3882QRiddle Kenneth G · Cherryville, NCBuilt 1971 · S/N 17259982N3882RPeterson Dennis W · Grenora, NDS/N 28-5855N3882ZHarwood Thomas K · Fairbanks, AKBuilt 1961 · S/N 18-7696N38836Angelle Martin · Slidell, LABuilt 1977 · S/N 28-7790592N3883PMontana Air Service Corp · Big Timber, MTS/N 18-4713N3883QAir Williams LLC · Arlington, TXBuilt 1971 · S/N 17259983N3883TPaul Novak Mdpc · Des Moines, IABuilt 1967 · S/N 28R-30210N3883XCallicoat Roger · Chesapeake, OHBuilt 1967 · S/N 187N3883ZBrossia Jerry L · Eagle River, AKBuilt 1961 · S/N 18-7697N38840Abdelmegid Shokria M · Desert Hot Springs, CABuilt 1977 · S/N 28-7790594N38841Savate Lloyd S · Berkeley, CABuilt 1977 · S/N 28-7790596N38842Scud Rat LLC · Valparaiso, INBuilt 1977 · S/N 28-7790597N3884DBryant Melvin Barry · Cascade, IDBuilt 1957 · S/N 34584N3884PKeffalos Chris S · Anchorage, AKBuilt 1955 · S/N 18-4717N3884QWrangell Mountain Air Inc · Palmer, AKBuilt 1971 · S/N 17259984N3884ZChestler Craig M · Soldotna, AKBuilt 1961 · S/N 18-7699N38852Hesston College · Hesston, KSBuilt 1977 · S/N 28-7790601N38859Castlerock Realty Investments LLC · Visalia, CABuilt 1977 · S/N 28-7716279N3885GRichland Aviation Inc · Sidney, MTBuilt 1976 · S/N 340A0220N3885MGough William N · Vancouver, WABuilt 1947 · S/N 12-2582N3885QGades Allen L Trustee · Montevideo, MNBuilt 1973 · S/N 18502207N3885TN3885t LLC · Howell, MIS/N 28R-30213N3885XAgledor Bob Sr · Edgewater, FLS/N 191N3885ZGlidewell Arthur C · Mc Neal, AZBuilt 1961 · S/N 18-7700N38861Mahaffey Jeffrey · Bristol, TNBuilt 1977 · S/N 28-7716281N38868Spain Brandon R · Pace, FLBuilt 1977 · S/N 28-7790602
Back to AD 2007-04-19 R1