AD 93-24-13
Registered aircraft · 231
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:93-24-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:93-24-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:93-24-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:93-24-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.
N51769Arizona 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, ORN51PDBcww LLC · Bakersfield, CAN529HJsh 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, ORN5690DRolfe Cameron R · San Mateo, CAN5690KAircraft Guaranty Corp Trustee · Oklahoma City, OKN5690PMultiaero Corp · Brooklyn, NYN5691MBrowning Robert F · Washington, DCN56926Bitwell Construction LLC · Hartville, OHN5692YSilverado Sales Inc · Orem, UTN5693RWaters Willie Frank Jr · Willits, CAN5694AStyer David B · Pendleton, ORN5694NBegley Edward · Glasgow, KYN5695AJacob Ricker · Ranchester, WYN5696MHubbard Benjamin L · Quogue, NYN5697MStanton Mark I · Spokane, WAN5698ELrh Equipment LLC · Pendleton, ORN56999Lofty Images LLC · Owosso, MIN5699DClear Lake Management Corp · Wilmington, DEN5699NStyer David B · Pendleton, ORN5699ULrh Equipment LLC · Pendleton, ORN5699VMesmer Robert F · Grand Island, NYN572HCordrey Kenneth R · Delmar, DEN58FSClark Mitchell P R · Drewsey, ORN594HKeading Helicopter LLC · Shoshone, IDFirst renewal noticeN595ARMiddle Fork Aviation LLC · Meadowview, VAN59AXCentral Virginia Aviation Inc · North Dinwiddie, VAN59FSRegistration Pending · Yazoo City, MSRegistration pendingN602HKing John H · Trumansburg, NY
Back to AD 93-24-13