AD 94-05-05 R1
Registered aircraft · 26,232
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.
N8020TVintage Aero LLC · Brownwood, TXN8021SKoehn Mark W · Elkader, IAN8021TSale Reported · Irvine, CASale reportedN8021XPatterson Roland O · Semmes, ALN8022ABackus John · Norton Shores, MIN8023SBalles Jeffrey J Sr · Hunker, PAN8023TKown Phyllis L · Hamilton, ALN8024BHatchie River Aviation LLC · Kalispell, MTN8024SOmlid Robert L · Watford City, NDN8024XRay Jonathan S · Richland, WAN8025FFurlong Kelly L · Athens, ALN8025SBranch Timothy · Russellville, ARN8025TAerial Advertising Services · San Jose, CAN8026LSayers Carl D · Vidalia, LAN80271Kansas Aviation Museum · Wichita, KSN80273Kinsler Kenneth K · Sand Springs, OKN80276Madden Ronald · Bronx, NYN8027AWoodbury William L · Smithwick, SDN8027LVan Kirk Malcolm R · Frederick, MDN8027XHall Rick L · Vancouver, WAN80281Ozarks Auto Show Inc · Hollister, MON8028BChandler Francis R · Anniston, ALN8029LBeasley Marvin T · Vidalia, GAN8029SPapich William · Boston, NYN8030BPauly Douglas A · Hooksett, NHN8030LScala Anthony J · New Hyde Park, NYN8030SWatson William E · Glen Rose, TXN8030THuff Tony D · Luthersville, GAN8030XKuykendall Kyle J · Austin, TXN8031AJims Aviation LLC · Fairfield, IAN8031FDevine Steven Anthony · Gilbert, AZN8032TSchwartz Matthew T · Winfield, WVN8033AColagross Levi · Beaverton, ORN8033TWunrow William · Decatur, TXN8033XHenrey Keith · Jasper, GAN8034BChapin Lyle E · Luverne, MNN8034FDavis Matthew B · Silsbee, TXN8035SLongstreth Seth Allen · Lancaster, OHN8035XHenke Shannon W · Bismarck, NDN8036BTeets Casey D · Inverness, ILN8036SStern Mark A · Tallevast, FLN8036UUniversity Of Maryland Eastern Shore · Princess Anne, MDN8037BExecutive 21 LLC · Noblesville, INN8037LSkyglide LLC · St George, UTN8038FJackovich Dennis A · Bettendorf, IAN8038SPainter Bryan · Renton, WAN8039AKenefick Christopher K · Rosamond, CAN8039TBay Dustin L · Chico, CAN803BBores Scott J · Huron, OHN803DJLyle Chase Thomas · Greenbrier, TN
Back to AD 94-05-05 R1