AD 85-02-05 R1
Registered aircraft · 8,920
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:85-02-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:85-02-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:85-02-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:85-02-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.
N5243ZJinkins Richard D · Rewey, WIN5246PYoyodyne Group Inc · Wilmington, DEN5247ZBard Alexander T · Portland, ORN5248PKnox Edward R · Gulfport, MSN5248ZTurner William J · Twentynine Palms, CAN5249ZCreger Paul L Jr · Springport, MIN5251PTaflinger Bradley P · Clarkdale, AZN5252PBrannan Andrew · Texarkana, ARN5252ZLamb Steve E · Big Bear City, CAN5253ALet Industries LLC · Lewes, DEN5253PSale Reported · Greeley, COSale reported, pending cancellationN5254ZPongracz Lajos Janos · San Antonio, TXN5255ZGeorge James C · Lenoir, NCN5256ZKirkpatrick Theodore J · Gwinn, MIN5257PAero Nautics Inc · Cheyenne, WYN5258PMosley Hardy · Elko, NVN5259PPacheco Carlos Antonio · Yuma, AZN525JFMoray Eel LLC · Vail, AZN5260ZBerreman Jeffrey P · Yakima, WAN5261PMon-Dak Consulting Inc · Plentywood, MTFirst renewal noticeN5261ZKnight Lynn L · Pineville, LAFirst renewal noticeN5263ZWilkins Jerry D · Toledo, WAN5264PBohmer James F · Tulsa, OKN5269YFlying K Aviation LLC · Quinlan, TXN5271ZElliot Kirk R · Tulsa, OKN5272AWelch Kevin R · Hartland, WIN5272PBombach James · Katy, TXN5272ZScheda Mark R · Brockport, NYN5273PSouthern View Energy Inc · Lula, GAN5274ZKotek Steven G · Sparta, WIN5275ZRobertson James W · Cashmere, WAN5278PRoebuck David M · Hamilton, GAN527JFBonnell Kenneth M · Ormond Beach, FLN5281PNardini Michael A · Dayton, OHN5283PGomes Andrew Jose · Arlington, TXN5283ZRegistered aircraftN5284ZRichard Waldren LLC · Newberg, ORN5287PFogleman Brian L · Stonewall, LAN5288ZSimmons Joshua I · Crescent City, CAN5289JHansen Larry G · Alliance, NEN5289PVaughan Michael P · Northbridge, MAN5289ZHenson Robert A · Mcloud, OKN5290PRegistered aircraftN5290ZColeman Kyle M · Sisters, ORN5291PBlack Randall D · Goodyear, AZN5291ZBay Area Recreational Flyers LLC · Midland, MIN5292PBrooksby Blake L · Pahrump, NVN5292ZHayes David A · Steward, ILN5294ZMorpeth Dorinda · Fortson, GAN5295ZFawcett Debra K · Baraboo, WI
Back to AD 85-02-05 R1