AD 99-05-13 R1 WD
Registered aircraft · 13,518
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-05-13-R1-WD')
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-05-13-R1-WD')
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:99-05-13-R1-WD') 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-05-13-R1-WD') 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.
N2064DLaing Malcolm B · Lubbock, TXN2064KDiamond O Ranch LLC · Fredericksburg, TXN20654Spatz Phillip D · League City, TXN2065QShalom Isaac R · New York City, NYN2065YAbel Instruments Inc · Riviera Beach, FLN2066ASky Time LLC · Wilmington, DEN2066DBair Jack Martin · Oklahoma City, OKN2066NBobo Kenneth · Auburndale, FLN2067LShort Final Aviation LLC · Siloam Springs, ARN2068DKelley Foy L · Oakdale, CAN2069CAztec Worldwide Airlines Inc · Wilmington, DEN2069DSchlegel Robert A · Windermere, FLN2069KFiloteo James · Woodinville, WAN2069YBeach Helicopter Services LLC · Chesapeake, VAN206BHand James K · Alton, ILN206CWAgri Med LLC · Belgrade, MTN206GPAdaptive Aero Inc · Wilmington, DEN206SBtpr Solutions LLC · Wilmington, DEN206TMPale Horse LLC · Mishawaka, INN206TVHpfm Inc · Vermillion, SDN2070WLeisure Air II LLC · Columbus, GAN2071BTrulson Gary S · Edgerton, WIN2071YRossiter Brahm J · Lemoore, CAN2072WNewsome Jeff · Blackwell, OKN2073DWitte Timothy P · Sharon Springs, NYN2073LBravo Wings II LLC · Grants, NMN2073WPlowden William E Jr · Shelby, NCN20748Registration Pending · Bethesda, MDRegistration pendingN2074GWinder Gary W Jr · Thornton, CON2074LTb7 LLC · Kalispell, MTN20753Beechcraft Heritage Museum Inc · Tullahoma, TNN20754Sweet Scott A · Naples, FLN2075AJacobs Nathan G · North Swanzey, NHN2075EStateline Aviation Inc · Dover, DEN2075LThompson Talley · Burgaw, NCN2075WCooper Jeffrey B · Eagle River, AKN2075XMehling Michael · Parish, NYN2076AThomas George P Jr · Woodstock, VTN2076DChild Benjamin H · Rexburg, IDFirst renewal noticeN2076LWhaley Keith · Pigeon Forge, TNN20778International Air Services Inc Trustee · Carson City, NVN20779Thomas Daniel Craig · Shady Shores, TXN2077AN2077a LLC · Lewes, DEN2077CBudarf James Philip · Graham, TXN2077DKloster Ethan · Tarzana, CAN2078WLawrence Dayle DBA · Scotia, CAN20798Beechcraft Heritage Museum Inc · Tullahoma, TNN2079LPlatinum Aviation LLC · Belvidere, TNN207AFFlying Burros Air Trucking Co · Wilmington, DEN207DWest Coast Aircraft LLC · Carson City, NV
Back to AD 99-05-13 R1 WD