AD 58-13-02
Registered aircraft · 68
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:58-13-02')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:58-13-02')
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:58-13-02') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:58-13-02') 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.
N1026BBazler Jack A Trustee · Boulder, CON11CFKrens Janet E · Purcellville, VAN120RDDecesare George D · Danville, CAN1235MRoan Christopher J · Jefferson, SDN12FHR&B Leasing And Finance LLC · Fresno, CAN144LHPaul John R · Hamilton, MTN154LHPaul John R · Hamilton, MTN154NWoods John · Eagle River, AKN155PAllman Air LLC · Blackstone, VAN15PCollins Jeffery S · Griffin, GAN15PHBindon Phil E · Wasilla, AKN207AFFlying Burros Air Trucking Co · Wilmington, DEN212GBailey Orin A · Homedale, IDN213DBall Frederick C · Harbor Springs, MIN2240Twin Bonanza LLC · Meridian, IDN227DSL & P Air LLC · Lees Summit, MON22BXCole K Matthew · Gillespie, ILN234HWestphal Ronald R · Aurora, ILN2400ZDerr Douglas N · Woodlands, TXN247CGParsons John C · Augusta, KSN261BWinnie Mae Inc · Tallahassee, FLN2755GOnderdonk Allyn K · Mills River, NCN277VCusick Christopher J · La Jolla, CAN295DEFly Direct LLC · La Porte, INN29YPeters Duane A · Anchorage, AKN308BClark Perry W · Pine River, MNN3274MPittsburgh Institute Of Aeronautics · West Mifflin, PAN3280ZPittsburgh Inst Of Aeronautics · W Mifflin, PAN3564BMach 4 Missions · Middleton, TNN3581BSpink Todd A · Mesquite, TXN35MCWallace James W · Elkins, WVN3635BPwc Aviation · Pine River, MNN3653BPlacebo Air LLC · Ridgecrest, CAN3670BAircraft Partner Holdings Inc Trustee · BerlinN3682BQualitair LLC Trustee · MichelstadtN3722BRui C LLC · Reddick, FLN3743BPittsburgh Institute Of Aeronautics · West Mifflin, PAN3755BYazdi Navid D · Beaverton, ORN3775BMummy Mountain Med LLC · Paradise Valley, AZN3784BOgorek Peter J · Milwaukee, WIN3795BCanyon Aero LLC · Fresno, CAN37WBSterling Aviation Services Inc · Wilmington, NCN38MMMusko Richard M · Wilkes Barre, PAN41DEOhlwiler Eric D · Oviedo, FLN4306DNightingale Matthew M · Rancho Cucamonga, CAN4357DStychworks LLC · Palmer, AKN4835ZCombat Air Museum Inc · Topeka, KSN4946BTippetts Kelly · Richmond, KSN4948BKrause Aviation LLC · Geneva, ILN4TB367 Estrella LLC · Ponte Vedra Beach, FL
Back to AD 58-13-02