AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-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:90-04-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:90-04-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:90-04-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.
N526WDenney Christopher R · Vicksburg, MSN526WPPickering Gordon D · La Pine, ORN526WRFlorida And Caribbean Flight Training LLC · Punta Gorda, FLN526WTDumler Marlin · Russell, KSN52700Air Transport Inc DBA · Las Vegas, NVN52701Cannon Michael A DBA · Blythe, CAN52702Christiansen Aviation LLC · Wilmington, DEN5270HR & D Aircraft Inc · Jamestown, NCN52713Austin-Walker Aviation LLC · Waukee, IAN52716Brewer Wesley G · Irvine, CAN52719Pynn David W · Gasport, NYN5271LBright Skies Sales And Leasing LLC · Hendersonville, TNN5271RAyala-Moore Kristopher · Tucson, AZN5271TOracle Aviation LLC · Omaha, NEN5271U71 Uniform Corp · The Villages, FLN5271WBrown Thrasher Aero LLC · Midland, GAN5271XRussell Steven N · Anchorage, AKN5271ZElliot Kirk R · Tulsa, OKN52720Rick Aviation Inc · Newport News, VAN52723Southern Aircraft Consultancy Inc Trustee · Casper, WYN5272AWelch Kevin R · Hartland, WIN5272RRichmond Pilots Corp · Linden, NJN5272ZScheda Mark R · Brockport, NYN5273LMancuso Dale · Dallas, TXFirst renewal noticeN5273RClear Prop Aviation LLC · Sterling, VAN5273SCarnegie Nursing Home Inc · Carnegie, OKN5273XToledo Jorge A · Miami, FLN52747Unicorn Papa Air LLC · Longwood, FLN52749Middle Tennessee State University · Murfreesboro, TNN5274HLincoln Skyways Inc · Lincoln, CAN5274LRetzer Daniel R · Rockford, ILN5274XStallings Aircraft Propeller LLC · Wynne, ARN5274ZKotek Steven G · Sparta, WIN52750Wieneke Robert A · Rockwall, TXN52756Fowler Jon E · Cal Nev Ari, NVN5275XKirschner David R · Mckeesport, PAN5275ZRobertson James W · Cashmere, WAN52765Benson Daniel P · Lake Placid, FLN5276HYagcioglu Deniz S · Eatonton, GAN5276LHaynie Sidney S · Sedona, AZN5276MBruehl Kenneth · Roseville, CAN5276WThird Step 2 LLC · Wilmington, DEFirst renewal noticeN5276XSanders Curtis E · Morrison, MON5277HTurner Edward J III · Mokena, ILN5277SFers Mitchell A · Stafford Springs, CTN5277WPerkins Nathan Zachery · Bonanza, ORN52786Moore Roger · Jonesboro, ARN52789Alameda Aero Club · Alameda, CAN5278DN5278d LLC · Dover, DEN5278RHussain Mahmoud Taimour Said · Miami, FL
Back to AD 90-04-06 R1