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.
N99981Sky High Leasing Services LLC · Lakeland, FLN9998DHarkins Cody · Grover, WYN9998PRhines Thomas M · Canton, TXN9998RSkyview Aviation LLC · Benton, KYN99991Genovese Mark A · Baltimore, MDN9999ALake Mark S · Erie, CON9999DAnderson Corlin L · North Branch, MNN9999UMcgee Allen C · Charlotte, NCN9999WScudder Adam · Orlando, FLN999ABBentrup Reinhard · Goleta, CAN999ADAllison Aviation LLC · Pueblo, CON999AEOtto Fabri · Sunny Isles Beach, FLN999AFThree Four Juliet LLC · Orange, CAN999ARD R Tripp Enterprises LLC · Omaha, NEN999ASSoutheast Aerosport LLC · Wellington, FLN999BATeslow Timothy W · Fairbanks, AKN999BNNestor Bob Howard · Pocatello, IDN999BPBuzako Richard F Trustee · Parker, CON999BTTravis Brent N · Hayden Lake, IDFirst renewal noticeN999BUUtah Firefly LLC · Wanship, UTN999BZWickware Charles S · Fresno, CAN999CKBatla John D · Columbus, TXN999CLCollette Dean R · Effingham, ILN999DATowner Andrew J Trustee · Leawood, KSN999DSSchorr David · New Port Richey, FLN999EDAero Design Works LLC · Ormond Beach, FLN999EMOombu LLC · Round Rock, TXN999EVJordan Helicopters LLC · Brady, TXN999FCWard Daniel W · Boonville, NCN999FLMatthews Aviation LLC · Hardinsburg, KYN999FSSindlinger Lyle · Puyallup, WAN999FTHolt Jacky D Jr · Bogalusa, LAN999FWMontgomery Aviation LLC · Zionsville, INN999GEWright Way Trailers Inc · Toddville, IAN999GKTaylor Craig E · Nantucket, MAN999GMLowe Gary E · Pikeville, KYN999HJSugiono Yudi S · Redlands, CAN999HPChisholm Hugh S Jr · Thomson, GAN999HRPage Edward C · Thornhurst, PAN999HSBurton John R · Punta Gorda, FLN999JKlenoski Brian D · Fulton, MIN999JMCrosby Lee R · Hyrum, UTN999JVWatson James W · Fairbanks, AKN999KKStavang Herman Wayne Trustee · Snelling, CAN999KWTeodoro Scott · Fox Island, WAN999LAAero Equities LLC · Ventura, CAN999LFPotts Rives · Dallas, TXN999LHRossi Christopher G · Paso Robles, CAN999MLesterville Land Holdings LLC · Ellington, MON999MROrth Jacob N · San Antonio, TX
Back to AD 87-10-06 R1