AD 94-05-05 R1
Registered aircraft · 26,230
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:94-05-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:94-05-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:94-05-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:94-05-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.
N8527GAcosta Alfredo · Yuma, AZN85281Weinhandl Lee A · Mandan, NDN8528BReiber Robert F · Riverside, CAN8528GTulsa Technology Center School Dist No 18 · Tulsa, OKN8528UKanning Brandon A · Graham, WAN8528XWilson Andrew · Sault Sainte Marie, MIN85293Willis Nelson W · Lebanon, TNN85294Burch Daniel C · Osceola, WIN8529BBlakely Jerry C · Winona, MSN8529JBrucks Mark D · Peachtree City, GAN8529XWheeler Kevin M Trustee · Comstock Park, MIN852BRobinson Alexander C · Reidsville, NCN852DWolcott Dennis L · Jasper, FLN852PGTop Notch Services LLC · Glen Cove, NYN8531EWarzecha Allan A · Holdingford, MNN8531JCelestial Kinetics Flight Academy LLC · Waupaca, WIN8532EBucciarelli Dominick F · Pueblo, CON8532JWerner Felix A · Picayune, MSN8532UMethe James L · Omaha, NEN85339Aviators Of Texas LLC · Georgetown, TXN8533BBungert Heidi J · Inver Grove, MNN8533XApex Aviation LLC · Highlands Ranch, CON8534ETyler Ronald A Jr · Valrico, FLN8534GBennett Julie L · Titusville, FLN8534ULusson Adam R · Cameron, WIN8534XGingrich Garrick Ray · Las Vegas, NVN8535GSpeedbird Aviation One LLC · Glenn Heights, TXN8535UGibbons Patrick C · Sunrise Beach, TXN8536EKaminski Daniel · Monee, ILN8536GMarcu David · Killen, ALN8536UIndigo Of South Fl Inc · Sunrise, FLN85371Williams Darrell W · Fayetteville, ARN85375Ropp Dorothy E · Poplar Grove, ILN85378Benger Jeffrey S · Bozeman, MTN8537EHoech Neal L · Sandpoint, IDN8537GNugent David R · Jensen Beach, FLN8537NDewald David J · Churubusco, INN8537UHarrington Richard E · Bly, ORN85380Holmgren Michael G · Kulm, NDN8538EAgaliotis Paul E · San Martin, CAN8538UMullaly George J · Rockville Centre, NYN85398Gann Gerald N · Conway, MON8539EWombles Michael · Greenwood, INN8539XLindgren Steven D · Holyoke, CON853CRegistered aircraftN853DCruz Keoni · Burlingame, CAN853EDavid 30 LLC · Boise, IDN8540JSale Reported · Lamar, COSale reportedN8540XN8540x LLC · Prescott, AZN8541GDeseh Sarah · San Diego, CA
Back to AD 94-05-05 R1