AD 2016-17-08
Registered aircraft · 4,096
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:2016-17-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-17-08')
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:2016-17-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-17-08') 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.
N1308GRed Over White Aviation · Louisville, KYN130HLFair Winds Aviation LLC · Shreveport, LAN130RACarter Distribution Lc · Salt Lake City, UTN1311GGranite Mountain Flight Training LLC · Prescott, AZN1313RAztexas LLC · Valley Farms, AZN1314GBas Part Sales LLC · Greeley, CON131PBTom Tatum Pa · Danville, ARN1321GInnovative Poultry Products LLC · Olar, SCN1322GSmetters Jeffrey L · Crystal Lake, ILN132RXJ + D Aviation Services LLC · Centerville, MAN1338GWings Air Charter LLC · Wisconsin Rapids, WIN1338UJstream Lc · Sheridan, WYN1339GLyon Aviation Inc · Pittsfield, MAN133CWDeniro Corp · Hampton, NHN133PCGilco Distributors · Santa Rosa, CAN1342GSpector Steven D · Glenview, ILN1346GClear Blue Aviation LLC · Melbourne, FLN1349GWings Of Grace Ministries Inc · Melbourne, FLN134GGGibson Gordon S Trustee · Pacific Palisades, CAN1351G310 LLC · Conover, NCN1359GEaglehead Aviation LLC · Tifton, GAN1361QLannigan Anthony Robert · Tucson, AZN1362CPaw Management Inc · Calimesa, CAN137Bigfoot Aviation LLC · Saint Michael, MNN1371GFall Gregory F · Hanson, MAN1379GTwo Golf Tango LLC · Albuquerque, NMN137DMiller Aviation LLC DBA · Huntington, INN1380GWalborn & Associates Inc · Mountain Home, IDN1383GKuper Carl J II · Dalhart, TXN138JGCloud Cruisers LLC · Falls Of Rough, KYN13BPN13bp LLC · Walla Walla, WAN13HLFreedom 421b LLC · Jacksonville, FLN13KGCarroll Jeffrey P · West Bloomfield, MIN13MFAeromedicos Gb Inc · Miami, FLNon-citizen corporation, flight hours not reportedN13PGJohnston Steven P · Coto De Caza, CAN13PKOaks Aviation LLC · Clear Lake, MNN140JRobert D Grace LLC · Amarillo, TXN140KMKnight Edge LLC · Clearwater, FLN140RBKessler Nicholas · Central Point, ORN140TPHickox Joseph · Rollins, MTN141DEEssex Lisa · Oceanside, CAN141GLSpring Branch Water Well Service W Texas Div Inc · Fort Stockton, TXN1420NKlomhaus Paul · Poplar, WIN1421MClausen Johan Robert · Las Vegas, NVN1421UAviation Services Of Tn Inc · Sparta, TNN142CTMiddleton Charles H · Hamilton, INFirst renewal noticeN142SDSch Aviation Inc Trustee · Kings LynnN143ELPremiere Aviation Inc · Concord, CAN143MGPatriot Air Inc · Maryland Heights, MON143SWBb&D Airways LLC · N Redngtn Bch, FL
Back to AD 2016-17-08