AD 96-03-13

Registered aircraft · 1,042

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:96-03-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-03-13')
  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.

N621AFBright Skies Mt LLC · Kalispell, MTBuilt 1978 · S/N BB-331N621EMN621em LLC · Ocala, FLBuilt 1981 · S/N LA-123N621JGWhite Aviation LLC · Ashford, ALBuilt 1981 · S/N BB-834N622KMK & M Equipment Co LLC · Chatsworth, CABuilt 1981 · S/N BB-491N625BWTechnology Service Corp · Arlington, VABuilt 1982 · S/N BB1090N627KMSpectre Aviation LLC · Dover, DES/N BE-93N629RPBasche Properties II LLC · Cleveland, OHBuilt 2007 · S/N BB-1984N6300FTenax Aerospace LLC · Ridgeland, MSS/N BB-1865N634BTurbo Air Charter LLC · Boise, IDBuilt 1974 · S/N BC-19N63593Rbr Development LLC · West Plains, MOBuilt 1979 · S/N BB552N635BDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N BC-49N636BDavid Aviation Inc DBA · Brandon, MSBuilt 1978 · S/N BC-61N636TAToth Financial Advisory Corp · Leesburg, VABuilt 2002 · S/N BB-1792N637WMOhmestede Industrial Services Inc · League City, TXS/N BB-1768N63LBBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N BB-1894N641TSLifewings II LLC · Harrisonville, MOS/N BB641N6451DEastern Stearman Inc Trustee · Leesburg, VABuilt 1982 · S/N BB-1009N646DRWilderness Aircraft Co LLC · Bloomington, MNBuilt 1980 · S/N BB-646N648DDDashdale Aviation LLC · Fort Dodge, IABuilt 1999 · S/N BB-1683N649JCDeja Air LLC · Morristown, TNBuilt 1980 · S/N BB-649N651TM305 Sky LLC · Boca Raton, FLBuilt 1981 · S/N BB-804N6531NBering Marine Corp · Seattle, WABuilt 1982 · S/N BB-1081N653TBCallaway Air LLC · Fulton, MOBuilt 1979 · S/N BB586N654BADepartment Of The Air Force · Hill Afb, UTBuilt 1982 · S/N BL-54N654FMN654fm LLC · Kalispell, MTBuilt 1980 · S/N BB-654N655SPNational Aviation Company LLC · Goodlettsville, TNS/N BB-1023N65MGRegistered aircraftN-number assigned (import), not yet registeredS/N LA-79N65MTM&M Transit LLC · Winter Park, FLS/N LA-38N65RTProfessional Travel Inc · La Porte, INBuilt 1975 · S/N BB-97N65TWRound Hound Holdings LLC · Lewes, DES/N BB-902N6604LShoals Aircraft Leasing And Operations LLC · Florence, ALS/N BB-1121N661BADepartment Of The Air Force · Hill Afb, UTBuilt 1982 · S/N BL-61N662BADepartment Of The Air Force · Hill Afb, UTBuilt 1982 · S/N BL-62N6644JOcean Aircraft Ltd · Virginia Beach, VABuilt 1982 · S/N BB-1031N667CCAeromont LLC · Billings, MTBuilt 2003 · S/N BB-1827N6683WWest Dakota Flight Co LLC · Miles City, MTS/N BB-1154N66BSValiair Limited Co Trustee · Casper, WYBuilt 1980 · S/N LA-40N6728HGuardian Flight LLC · Lewisville, TXBuilt 1984 · S/N BB-1193N672HD49 Papa Hotel LLC · Sioux Falls, SDBuilt 1980 · S/N LA-33N675RNLakeside Aviation LLC · Redwood City, CABuilt 1999 · S/N BB-1676N676WTHat L Management Inc · Midland, TXBuilt 1981 · S/N BB-872N678MMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1981 · S/N BB-908N678SSRca Aviation 1 LLC · Tempe, AZS/N BB-1021N680CAMetrea Special Aerospace Isr Inc · Oklahoma City, OKBuilt 1999 · S/N BB-1681N682DRN682dr LLC · Clovis, NMBuilt 1976 · S/N BB-130N686ACStm Air LLC · Ocala, FLBuilt 1981 · S/N BE-127N686CFAt Aero LLC · Wilmington, DEBuilt 1982 · S/N BB-1085N68DKDago LLC · Mcallen, TXBuilt 1980 · S/N LA-56N68MNGuardian Flight LLC · Lewisville, TXBuilt 2006 · S/N BB-1962N68MUPark Avenue Group Inc · Stuart, FLBuilt 1978 · S/N BE-37
Back to AD 96-03-13