OpenAirDocs.org
AD 99-08-07

Registered aircraft · 337

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

N1002XMd Helicopters LLC · Mesa, AZS/N 0362FFN1004RMd Helicopters LLC · Mesa, AZS/N 0363FFN1005GMd Helicopters LLC · Mesa, AZS/N 0364FFN1006CMd Helicopters LLC · Mesa, AZS/N 0365FFN1006MMd Helicopters LLC · Mesa, AZS/N 0366FFN1006TMd Helicopters LLC · Mesa, AZS/N 0367FFN1008HMd Helicopters LLC · Mesa, AZS/N 0369FFN102CGSale Reported · Surprise, AZSale reported, pending cancellationBuilt 1998 · S/N LNO85N102CQChatham County · Savannah, GABuilt 1999 · S/N 0901FFN103CGCity Of Burbank · Burbank, CABuilt 2006 · S/N LN102N108PPCity Of Pomona · Pomona, CABuilt 2008 · S/N 0578EN109LBVertol Systems Company Inc · Destin, FLBuilt 1991 · S/N 0455EN124PDH & O Helicopters Inc Trustee · Wilmington, DEBuilt 1992 · S/N 0502EN125KWAurora Aviation Services Inc · Delta Junction, AKBuilt 1989 · S/N 0336EN126KWHlh Leasing LLC · Wilmington, DEBuilt 1991 · S/N 0489EN12THHarding Tim · Bryan, TXS/N 0224EN13KJCarlston Carl Vaughn · Murray, UTBuilt 1991 · S/N 0444EN155NRState Of Minnesota · Grand Rapids, MNBuilt 2015 · S/N 0623EN1576FCity Of Houston Police Dept · Houston, TXBuilt 2006 · S/N 0802FFN15THHeliservice LLC · Wilmington, DEBuilt 2003 · S/N 0564EN16002Commonweath Of Massachusetts · East Boston, MAS/N 0194EN1602LSaxton Helicopter Leasing LLC · Plymouth, MIS/N 0225EN1604ZDept Of Fish Wildlife And Parks · Helena, MTBuilt 1989 · S/N 0341EN16050Venturi Aviation LLC · Missoula, MTS/N 0276EN1605KCounty Of Gwinnett Georgia · Lawrenceville, GABuilt 1988 · S/N 0604FFN16062Flight Inspection LLC · Springdale, WABuilt 1989 · S/N 0349EN16069Paragon Air Group · Fort Worth, TXBuilt 1990 · S/N 0433EN1610BBlackstead Investments Inc · Boise, IDBuilt 1991 · S/N 0480EN163LHeli Fly Inc Trustee · Wilmington, DEBuilt 2019 · S/N 0317FFN165HMidvale Air Research LLC · Lewes, DEBuilt 1985 · S/N 0150EN16EYCarleton Inc Trustee · Wilmington, DEBuilt 1992 · S/N 0501EN175JKJk Aviation LLC · Kerman, CABuilt 2000 · S/N 0143FFN1808Gwinnett County Police Dept · Lawrenceville, GABuilt 2019 · S/N 0318FFN18CPPeoples Properties LLC · Tucson, AZBuilt 1990 · S/N 383EN18FFHeliservice LLC · Wilmington, DEBuilt 2006 · S/N 0146FFN18GHCity And County Of Honolulu · Honolulu, HIS/N LN014N199FFHeavy Lift Helicopters Inc · Fresno, CABuilt 1994 · S/N 0099FFN19FFHeliservice LLC · Wilmington, DEBuilt 2010 · S/N 0718FFN209ECYavapai County · Prescott, AZBuilt 2007 · S/N RN074N20ATFlight Trails Helicopters Inc · Mesa, AZBuilt 1994 · S/N 0113FFN20FLLocker Fred · Muleshoe, TXBuilt 2008 · S/N 0592EN215MBunn Mary E · Williamstown, WVBuilt 1997 · S/N LN083N220PDCity Of Oakland · Oakland, CABuilt 1993 · S/N 0509EN228KKKeagy Ken · Central Point, ORBuilt 1987 · S/N 0248EN229HLAviation Advantage Inc · Tabor City, NCBuilt 1995 · S/N 0519EN234RFMhoc LLC · Pensacola, FLBuilt 1987 · S/N 0255EN241JHChatham County Mosquito Control · Savannah, GAS/N 0233EN261VSVertol Systems Company Inc · Destin, FLS/N RN061N266VSVertol Systems Company Inc · Destin, FLBuilt 2002 · S/N RN066N297ECounty Of Kern · Bakersfield, CAS/N 197E
Back to AD 99-08-07