AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.
N8853JN8853j LLC · Oak Park, ILN8853PGebhart Kevin E · Burley, IDN8854CMid Continent Aircraft Corp · Hayti, MON8854DKidd Clifford L Jr · Monahans, TXN8854LPfs Air Inc · Yellville, ARN8854WCherokee235 LLC · Kalispell, MTFirst renewal noticeN8854YSeeds John S Jr Trustee · Tequesta, FLN8855NIndy Distributors Inc · Noblesville, INN8855PTja Pop Ltd · Dix Hills, NYN8856CBritton Mark W · Wasilla, AKN8856FRotorcraft Unlimited LLC · Brooksville, FLN8856JFifty Six Juliet LLC · West Lafayette, INN8856LRuales Edison R · Miami, FLFirst renewal noticeN8856NGrant Shane J · Cape Coral, FLN8856WSouthard Brian W · Washington, OKN8857Aviation Management Systems LLC · Fallbrook, CAN8857DHollan William E Jr · Winston Salem, NCN8857JNguyen Tu K · Costa Mesa, CAN8857MDunn Brady · Gilmer, TXN8857NWolf Terry T · Lake Katrine, NYN8857YLewis Leslie S · Glendale, AZN8858JBirdie N88 LLC · Conifer, CON8858PMachmiller A A · San Jose, CAN8858WCassidy Kirk B · La Canada, CAN8859DBbc Group LLC · Sanford, NCN8859NThrash Enterprises LLC · Clarksville, TNN8859PGowins John C · New Philadelphia, OHN885ACWingsleasing LLC · Wichita, KSN885ATDot Aviation LLC · Wilmington, DEN885FTFlorida Institute Of Technology · Melbourne, FLN885HAFox Airways LLC · Wasilla, AKN885LHNomad Aircraft Leasing And Sales LLC · Panama City Beach, FLN885SABlevins Edgar R · Zachary, LAN885SMDews Robert Mark · Jefferson, TXN8860DCooley Tony A · Dallas, ORN8860JBjg LLC · Langdon, NHN8860WLayth Air LLC · Martin, TNN8861FMurtaza Syed S · Minneapolis, MNN8861NMcdonald Timothy A · Rush City, MNN8861PForney Garry L · El Centro, CAN8861WFrancavilla Charles · Fremont, CAN8862FAircraft Guaranty Corp Trustee · Oklahoma City, OKN8862LTisdale Matthew · Alameda, CAN8862NHatley Wayne S · Hermitage, TNN8862TAdams Donald L · Huntsville, ALN8862VInternational Air Services Inc Trustee · Carson City, NVN8862YState Of Montana · Helena, MTN8863Lilly Daryl A · Winterset, IAN8863DSanders Darrel T · Camp Douglas, WIN8863FCain James W · Big Rapids, MI
Back to AD 87-10-06 R1