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.
N750THMiller Robert T · Norwood, NCN7516NDelis Balentine Jeremy W · Phoenix, AZN7517NEagle Squadron Inc · The Villages, FLN7518NHarper Darin M Trustee · Independence, ORN751DSloan Parker Ryan · Pryor, OKN751PPPlane White Corporation · Sunriver, ORN7521RWatchill LLC · Traverse City, MIN752DSpoltman James H · Oak Harbor, WAN7542DBeach Bound Baron LLC · Modena, NYN754PMid Continent Harley Davidson Inc · Wichita, KSN75544Richardson Robert L · Rch Palos Vrd, CAN755BABeek Nigel A · Pembroke Pines, FLN755DN755d Llp · Sidney, MTN755RTired Iron Aviation LLC · Sheridan, WYN755RPBas Part Sales LLC · Greeley, CON755TAg Air Ltd · Harwood, NDN755XLandis David A · Perryton, TXN755YMathews David J · Blue Earth, MNN75614Schmidt Victor M · Corbett, ORN756BFrymire Terry R · Floresville, TXN756EEHoster Keith DBA · Gordon, TXN756TN756t LLC · North Royalton, OHN757AMKhorzad Kaveh · Austin, TXN757APMcnamara William T · Memphis, TNN757DWilcox Stacy S · Parker, CON757DBAviation Investments Inc · Virginia Beach, VAN757ERJohnson Nathaniel D · Attalla, ALN757FVintage Aircraft LLC · Leesville, SCFirst renewal noticeN757HZInabnit Kevin J · Bozeman, MTN7584DBuehler Benjamin M · Issaquah, WAN7587DCelco Co · Mahwah, NJN7591DMidland Avionics LLC · Louisville, KYN7594HVtanza LLC · Indianapolis, INN759VLBarto Jerrel · Kula, HIN75AMAirjohn LLC · Cheyenne, WYN75ATGta Air Inc · Addison, TXN75BKN75bk LLC · Midland, TXN75CAAnthrop Donald C · Orlando, FLN75CSWeskap Hangar Management LLC · West Grove, PAN75DJValiair Limited Company Trustee · Casper, WYN75GJSkydive Greene Co Inc · Xenia, OHN75HPN5949s LLC · Hereford, TXN75JCWilliams Austin · Valdosta, GAN75JGWhisenant Roy H II · Poway, CAN75KGKahn Karen M Trustee · Santa Barbara, CAN75PRScott Jerry · Wingate, TXN75RJones Daniel · Cypress, TXN75RMDodson International Parts Inc · Rantoul, KSN75SSMurdock Kent A · Roll, AZN75TAPigott Michael · Brandon, MS
Back to AD 99-05-13 R1 WD