AD 2005-10-13
Registered aircraft · 1,224
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:2005-10-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:2005-10-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.
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:2005-10-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:2005-10-13') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N86STAerial Solutions Inc · Tabor City, NCN874MAnastasia Mosquito Control District · Saint Augustine, FLN8809WFlt Services LLC · Woods Cross, UTN885MCPolk County · Bartow, FLN888EVTop Flight Aviation Of Mississippi LLC · Picayune, MSN888MHKa Air LLC · Shelby, NCN888SWSeawind Mjw LLC · Wappingers Falls, NYN88FKSt Louis Airmotive LLC · Wilmington, DEN88HCTri-Rotor Spray & Chemical · Ulysses, KSN890RPAmerican Ag Aviation Inc · Five Points, CAN890SPWest Virginia State Police · South Charleston, WVN895SPWest Virginia State Police · South Charleston, WVN8969FTeryjon Aviation Inc · Bluefield, VAN8972MRocky Mountain Oyster Co Aviation LLC · Kalispell, MTN8974MDd Choppers LLC · Mc Laughlin, SDN897BCIntersouth Inc · Santo DomingoN897UFRegistered aircraftN89GPOsprey Aviation LLC · Green Bay, WIN89PHProvine Helicopter Service Inc · Greenwood, MSN89TTBrunskill Stephen D · Lodi, CAN8AUDodson International Parts Inc · Rantoul, KSN8QDHelicopters Inc · Wilmington, DEN8QVD H Helicopter Inc · Mascoutah, ILN8UFIntegrity Aircraft Title Holdings LLC · Portland, ORN8VUOwen Aviation Services LLC · Dallas Center, IAN8YJHelicopters Inc · Cahokia, ILN900HHHmc Lift LLC · Wilmington, DEN9014QScotts Helicopter Services Inc · Le Sueur, MNN90307Smith David C · Brewster, WAN904BASky One Helicopters LLC · New Haven, MON904HMHangar 3 Zero LLC · Las Vegas, NVN907BHBering Air Inc · Nome, AKN909AGFtav LLC · Mesa, AZN90CLHelicopters Inc · Wilmington, DEN90MFBlue Air Training Corp · Las Vegas, NVN90RHLarson Michael A · Perham, MNN91018Two Wise Guys Aviation LLC · Le Sueur, MNN910PGPrince Georges County · College Park, MDN911AKMse Air Group Inc · Ciales, PRN911ALAir Methods LLC · Greenwood Village, CON911ANAlaska Tactical Aviation LLC · Palmer, AKN911BYAmerican Honor Foundation Inc · Melourne, FLN911CPSt Louis County Police Department · Clayton, MON911HHEwing Flying Service LLC · Morganza, LAN911JRGlobal Rescue Jets LLC · Boca Raton, FLN911PGPrince Georges County · College Park, MDN911UDIndian River County Sheriff'S Office · Vero Beach, FLN911UUKottman Marvin G · West Point, NEN912PCTri-Rotor Spray & Chemical · Ulysses, KSN913RLAero Leasing Inc · Medford, OR
Back to AD 2005-10-13