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.
N9296QReichert Aviation Enterprises LLC · El Cajon, CAN9296SShindel Mark · Los Gatos, CAN9298SQuality Aviation Inc · Atlanta, GAN9299SSky King Flying Club Inc · Jackson, OHN929BJNextlinq Solutions Inc · Irvine, CAN929DVSiegfried Rand W · Sausalito, CAN929JDMake Aviation Great Again LLC · Kalispell, MTN929QMorlen Aviation Mechanical And Electrical Svcs LLC · Conroe, TXN92CRWhite Nancy Ann · Queenstown, MDN92DTJcb Aviation LLC · Terrell, NCN92HBDawe Jon · Collierville, TNN92JWKennedy Donald R Jr · New Philadelphia, OHN92NJDan Cox LLC · Troutdale, ORN92RMAutry Marbella A · Montrose, CON92RWInternational Air Services Inc Trustee · Carson City, NVN92SEN92se LLC · Santa Barbara, CAN92SLApd LLC · Madison, OHN92WAAdamson Donald R · Lonoke, ARN92WBZ Aircraft LLC · Seminole, ALN92WWMoran Richard J · Balsam, NCN9300SExcalibur Unlimited LLC · West Park, FLFirst renewal noticeN9301YOxx William A Trustee · Wellington, NVN9302QSmith Winston C · Colleyville, TXN9302SLayden John M Jr · Moyock, NCN9302YChupito Sabrocito LLC · Paso Robles, CAN9303YBoden Josh L · Waldo, KSN9304QK Factor Aircraft Corp · Jupiter, FLN9305YN9305y LLC · Wichita, KSN9306YTff Inc · Dexter, MIN9307SRearick Scott P · Frederick, MDN9308QMt Zephyr Enterprises LLC · Yorktown, VAN9309QBehrent Carl D · Granbury, TXN930AAN930aa LLC · Memphis, TNN930DBKropp Christian Trustee · Azle, TXN930PCTrust Aviation LLC · Columbia, SCN930RGarrett David B · Polson, MTN9311YWolf Zachary J · Rochester, MNN9315SBradford Alvin L · Northville, MIN9315YAero Con Brio LLC · Wichita, KSN9319SMeyn Joseph · San Antonio, TXN931BSorenson Michael Justin · Pasco, WAN931EJetco Leasing · Salinas, CAN931PCJac Tay LLC · Saint Louis, MON931RDMorgan Gabriel A Sr · Newport News, VAFirst renewal noticeN931VBaker Matthew T · Shipman, ILN9320QT-Wing Aviation LLC · Pompton Plains, NJN9322SBrungard Thomas L · Walnut Creek, CAN9322YRice Christopher · Albuquerque, NMN9323YAgerton William David Jr · Weatherford, TXN9324SBas Part Sales LLC · Greeley, CO
Back to AD 99-05-13 R1 WD