AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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.
N2527VWright James C · Sulphur Springs, TXN2527YSuazo Tito L · Glendale, AZN2528JMichael Matthew C · Ames, IAN2528KDrake Keith · Monroe, NCN2528LWings Of Faith · Stevensville, MTN2528YHock Adam · Ankeny, IAN2529JSale Reported · Geneva, OHSale reportedN2529KCully Dean F · Anchorage, AKN2529UCampbell Alto L III · Pike Road, ALN252ACStewart Brent E · Oro Valley, AZN252BYLance Christopher D · Vacaville, CAN252CRMcvay Thomas T · Minneapolis, MNN252JMMccallister Billy G · Virginia Beach, VAN2530LSholes Lance M · Oregon City, ORN2530PKingsley Kiman J · Miller, MON2530YHarbour William T Jr · Mobile, ALN2531DAnderson Eric J · Great Falls, MTN2531JCrowder Jr Thomas E · Whitesburg, GAN2531LAiken Justin M · Arden, NCN2532FQuinn Michael A · Ruby, AKN2532JDel Mar College District · Corpus Christi, TXN2532UMills Randall J · Monroe, MIN2532YBatie Gregory T · Rogers, ARN2533CParker Michael T Trustee · Denton, TXN2533DAircraft Leasing LLC · Princeton, MNN2533FMacdonald Craig R · Sonoma, CAN2533NPhillips James T · Hickory Corners, MIFirst renewal noticeN2534FCentral Virginia Aviation Inc · North Dinwiddie, VAN2534YTorres Gerardo · Gurabo, PRN2535CHulme Timothy L · Wickenburg, AZN2535TWilkinson Bobby W · Mckinney, TXN2535YFleck Timothy · Hurst, TXN2536CLibbey Eric · Santa Ynez, CAN2536DWilliams Rod D · Steamboat Springs, COFirst renewal noticeN2536LLink Kim D · Golden Valley, NDN2536UNeal Tommy G · Sulphur Springs, TXN2536VZimmer Joseph J · Marion Center, PAN25376Cosgrove Mark A · Grand Ledge, MIN2537CNealon Robert M · Southbury, CTN2537HMaddock Jay B · Sugar Grove, ILN2537LOneill Timothy J · Clyo, GAN2537VWeatherly Richard A · Spokane Valley, WAN2538DHanley Olan B II · Bellevue, WAN2538FHill Ag-Air LLC · Bancroft, IDN2538UHall Chad B · Baytown, TXN2538YChapman James Tod · Portland, ORN2539NNichols Raymond L · Saint Anne, ILN2539ULoes Todd A · Waterloo, IAN2539YOly LLC · Onida, SDN253EHGreene County Flying Club · Waynesburg, PAFirst renewal notice
Back to AD 94-05-05 R1