AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N9993YStukenberg Brian · Byron, ILN99948Florida State College At Jacksonville · Jacksonville, FLN9994DKnudsen Ernest W Jr · Ennis, TXN9994GTre Aviation Corp · Wilmington, DEN9994LMclanahan John P · Culpeper, VAN9994UKaczmarek John F · Weatherford, TXN9994VWings Over Texas Holdings LLC · Denton, TXN9995CCullman Dan H · Kent, WAN9995LGoertz Anton O · Santa Fe, NMN9995RBig Sky Navigation & Flight Training LLC · Bristol, VAN9995UAero Cats Of New Hampshire LLC · Plainfield, NHN9996CHackwell Calvin · Enoch, UTN9996LPadilla Francisco · Spring, TXN9996QWhite Ashlyn J · Renton, WAFirst renewal noticeN9996USapir Kfir · Las Vegas, NVN9997LTaylor Eric C · Mooresville, INN9997UGuth Giora · Lexington, MAN9997VBecker Philip J · Ocean Isle Beach, NCN9997YLehrer James R · Thief River Falls, MNN99981Sky 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, MNN9999LWhitman John L · Coopersville, MIN9999UMcgee Allen C · Charlotte, NCN999ADAllison Aviation LLC · Pueblo, CON999AFThree Four Juliet LLC · Orange, CAN999ARD R Tripp Enterprises LLC · Omaha, NEN999BATeslow Timothy W · Fairbanks, AKN999BPBuzako Richard F Trustee · Parker, CON999BTTravis Brent N · Hayden Lake, IDFirst renewal noticeN999BUUtah Firefly LLC · Wanship, UTN999BZWickware Charles S · Fresno, CAN999CGEdling Leon K · Colorado Springs, CON999CLCollette Dean R · Effingham, ILN999DSSchorr David · New Port Richey, FLN999EOwens Wilbur · Rancho Palos Verde, CAN999EDAero 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, IAN999GMLowe Gary E · Pikeville, KY
Back to AD 81-18-04 R2