AD 89-22-16
Registered aircraft · 1,050
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:89-22-16')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:89-22-16')
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:89-22-16') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:89-22-16') 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.
N124HBVanguard Aircraft Trust Company LLC Trustee · Fort Lauderdale, FLN125SBBay Venture Management LLC · Atlanta, GAN125TKSupreme Sky LLC · Farmers Branch, TXN125XPN125xp LLC · Wilmington, DEN126KLAircraft Fidelity Corp Trustee · Dover, DEN127VLE D Santos & Associates LLC Trustee · Wilmington, DEN128BGE D Santos & Associates LLC Trustee · Wilmington, DEN129GBCapital Cost Corp · Wilmington, DEFirst renewal noticeN12RPRoyal Air Freight Inc · Waterford, MIN12SYMcwalsh LLC · Dover, DEN130YBMwl Aviation 1 LLC · Miami Lakes, FLN132CESouthern Energy Transport LLC · Shelbyville, TNN133EJHale William Trustee · Loveland, CON133KSJyh Aviation LLC · Jacksonville, FLN135SHMed Air LLC · Wilmington, DEN136JPCasmos LLC · Wilmington, DEN137SHDream Global Parts LLC · Lawrence, KSN139LRBank Of Utah Trustee · Salt Lake City, UTN13ADN13ad LLC · Dover, DEN140WHVarney Aviation LLC · Bangor, MEN141AELake Superior College · Duluth, MNN141JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN143LJBchjet3 LLC · Greer, SCN145LRCalchem Transportation LLC · Stockton, CAN146EXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN147GXAltair Aviation LLC · Missoula, MTN14NAAnschutz Corp · Englewood, CON14PBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN150EXDodson International Parts Inc · Rantoul, KSN150JGHardaway Capital Group One LLC · Stateline, NVN150SBRegistration Pending · Anchorage, AKRegistration pendingN152FJVictory Outreach International · San Dimas, CAN154LAAnschutz Corp · Englewood, CON154RRN154rr LLC · Wilmington, DEN155ERAir Medical Services LLC · Denver, NCN156NSNunya LLC · Costa Mesa, CAN156REOnward & Upward Aviation LLC · Lake Mary, FLN158ECHhh Aviation LLC · Des Moines, IAN159RABar Aircraft Leasing LLC · Waterford, MIN15BADodson International Parts Inc · Rantoul, KSFirst renewal noticeN15RKPlane Part Solutions LLC · Lake Park, FLN15VXTvpx Ars Inc Trustee · North Salt Lake, UTN161SDSierra Delta Aviation LLC · Boise, IDN163CKKalitta Charters LLC · Ypsilanti, MIN163JMGainesville Aircraft Sales Inc · Gainesville, FLN164GBNewcastle Capital Group LLC · Dallas, TXN166RARoyal Air Freight Inc · Waterford, MIN166RLLm Aeropsace Corp · Deerfield Beach, FLN167BRHhf Aviation LLC · Nashville, TNN16LJLear Holding Corp · Wilmington, DE
Back to AD 89-22-16