AD 2002-08-03
Registered aircraft · 276
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:2002-08-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-08-03')
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:2002-08-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-08-03') 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.
N43MHKorb Thomas M · Owasso, OKN44XAMackechnie Martin J · Palm Harbor, FLN454PCannon Travis H II · Corinth, TXN46MUMedic Choppers LLC · Springdale, ARN4874Goin Jeff Trustee · Polk City, FLN4878Medic Choppers LLC · Springdale, ARN4889Albert Lea Arpt Inc · Albert Lea, MNN494HSale Reported · West Palm Beach, FLSale reported, pending cancellationN501EHDupont Pierre B · Menominee, MIN503PDWjt Investments LLC · Gurley, ALN50AZBenson Aviation LLC · Mehoopany, PAN50DRAdf Helicopters Inc · Brewster, WAN51659Hawk Robert S · Argyle, TXN51665Rotor-Lift LLC · Swartz Creek, MIN51693Borreson Anthony · Reno, NVN51699Styer David B · Pendleton, ORN516BYIberlin James M · Gillette, WYN51723Rhoads Timothy C · Logan, NMN51735Styer David B · Milton Freewater, ORN51739Quality Aero LLC · East Aurora, NYN51757Spencer John S · Indian, AKN51758Enstrom Instruction LLC · Newark, DEN51768Stocker Concrete Co · Gnadenhutten, OHN51769Arizona Skies Aviation LLC · Scottsdale, AZN51770Lrh Equipment LLC · Pendleton, ORN51774Salaika Timothy A · Danbury, TXN51778Medical Evacuation Disaster Intervention Corps · Springdale, ARN51787Holder Michael T · Whitesburg, GAN51788Rhoads Timothy C · Logan, NMN51789Breyer Charles A · Lewes, DEN518EGStyer David B · Pendleton, ORN519HCain James W · Big Rapids, MIN51PDBcww LLC · Bakersfield, CAN520HKirsch Kenneth L · Carneys Point, NJN529HJsh Farms Inc · Hermiston, ORN52PDAviation Endeavors LLC · Houston, TXN539HSharkey'S Helicopters Inc · West Lebanon, NHN53PCMckenney Bret K · Billings, MTN53SABorreson Anthony · Reno, NVN542HGraham Jack D · Hamilton, TXN544HLrh Equipment LLC · Pendleton, ORN549HBazemore Dennis A · Ingleside, TXN554HSouthworth Elizabeth A · Igo, CAN565XMackechnie Martin J · Palm Harbor, FLN56874Styer David B · Pendleton, ORN5687PBrown Clifford J · Hoschton, GAN5688RLowell Darryl S · Anchorage, AKN5688TJoe Koch Construction Inc · Youngstown, OHN5689NRobinson Ryan A · Burbank, CAN5690BK & L Aerial LLC · Echo, OR
Back to AD 2002-08-03