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.

N41MSJennings William K · Chandler, AZBuilt 1967 · S/N 28-22716N41MTX2nsat Inc · Petaluma, CABuilt 1977 · S/N 18265725N41MWWoodard Michael G · Northport, ALBuilt 1978 · S/N M-2103N41NCTiger 41nc LLC · Malvern, PABuilt 2004 · S/N 10234N41NHHartz Norman E · Gardnerville, NVBuilt 1997 · S/N E-3139N41NRSholy Fred · Granada Hills, CAS/N 340A0488N41PLTj Air Holdings Inc Trustee · Wilmington, DES/N 30-1293N41PPKansas Aviation Museum · Wichita, KSBuilt 1985 · S/N 001N41PSGarwood Brandon A · Poland, OHBuilt 2003 · S/N 6058N41PVBear Nathan Eugene · Cove, ORBuilt 1979 · S/N 28-8016063N41PWWhitehouse Thomas · Bethlehem, GABuilt 1985 · S/N 527N41QBBravo Charlie LLC · Johnston, IABuilt 1979 · S/N 18-7909067N41QCMark J Heistad · Covington, LAS/N TE-150N41RDFlip-Flop LLC · Wray, COBuilt 1981 · S/N B1981N41RHMile High Rotors Inc · Indian Hills, COS/N 14274N41RTVyfvinkel Frederick J · New Smyrna Beach, FLBuilt 1964 · S/N TC-666N41RVUmbricht Marc · St-PrexNon-citizen corporation, flight hours not reportedS/N 1992N41SContinental National Aviation LLC · Tampa, FLBuilt 2019 · S/N 30061CN41SAIntegrated Design And Supply Inc · Crystal Lake, ILBuilt 2005 · S/N 1507N41SBBrillaud Stephen A DBA · Germantown, TNBuilt 1964 · S/N D-7608N41SGSunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 28R-7837288N41TBMarikan LLC · Strongsville, OHS/N 485N41TCMentor Flight LLC · Mercer Island, WABuilt 1954 · S/N CG-73N41TGBusch John · Chapin, SCBuilt 1973 · S/N TC-1581N41THLammers Ross L · Cumming, GABuilt 1997 · S/N S1747N41TRBushre David N · Janesville, WIBuilt 1993 · S/N 1N41TTAlvis Michael Ernie · Sparta, TNBuilt 1972 · S/N 414-0263N41TWFair James A · Derby, CTBuilt 1961 · S/N D-6563N41USLucas Gregory · Santa Rosa, CAS/N TD-624N41VBVon Bevern Brian J · Overland Park, KSBuilt 2008 · S/N 21583N41VEJrvc Transportation Inc · Boston, MABuilt 2018 · S/N 14103N41VKGalaxy Aviation LLC · Nantucket, MABuilt 1981 · S/N E-1885N41VRWalker Vincent Paul · Medford, ORBuilt 2006 · S/N L2K-280N41VVTurner Andrew · Orange Beach, ALBuilt 2004 · S/N 1231N41VZCarver Co LLC · Chugiak, AKBuilt 1976 · S/N 7026CN41WBendure Mark · Overland Park, KSBuilt 1969 · S/N 1BWN41WAHackler Jeanette D · Arlington, TXBuilt 1967 · S/N 28R-30211N41WBEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 2034N41WTPremiere Aviation Inc · Concord, CABuilt 1982 · S/N 421C1257N41XPIra Ellis LLC · Jackson, TNBuilt 2002 · S/N 0206N41YYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 21063653N41ZYBailey Thomas A · Claymont, DES/N 28-3087N4200Burdick Rich · Montrose, COBuilt 1975 · S/N 674N42002Kuntz Jonathan W · Yorktown, VABuilt 1968 · S/N 18258801N42004Haskell Airport Inc · Coweta, OKBuilt 1999 · S/N 18280446N42006Thompson Jeffrey L · Scandia, KSBuilt 1968 · S/N 18258804N42007Southeastern Oklahoma State University · Durant, OKBuilt 1999 · S/N 17280744N4200BCondair Flyers Inc · Latham, NYBuilt 2000 · S/N 2843319N4200HFoss David K · Anchorage, AKBuilt 1948 · S/N 14-3N4200XLeazer Johnathon E · Ozark, ALBuilt 1971 · S/N 5200
Back to AD 2007-04-19 R1