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.
N6231RSando Mark T · Carson City, NVN6232RBeavers Benjamin K · Omaha, NEN6232TDavenport Richard B · Danbury, TXN6233S33sierra LLC · Soldotna, AKN6234RFly Big Sky LLC · Missoula, MTN6234SCorbin M Stuller · Yoder, INN6235ELee William Lewis · Gilbert, AZN6235KCall One Inc · Clarinda, IAN6235SRudnik Zachary A · Minto, NDN6236UCaceres Rossel Bayardo J · Jamesville, NCN6237ESale Reported · Brandon, MSSale reportedN6237RBorden Jonathan Wilfred · Londonderry, NHN6237TReinhardt Larry L · Clackamas, ORN6238RRegistration Pending · Preston, IDRegistration pendingN6238TLocklear Benjamin M · Mangum, OKN6239EKnutson Wayne R · Thompson, NDFirst renewal noticeN6239RBala Engineering Pllc · Hawkins, TXN6239TEvans Cliff D · Boulder Creek, CAN623APHartman Michael F · Montclair, CAN623CBWalak William J · South Berwick, MEN623LCForbes Kenneth W · Agua Dulce, CAN6240EDgcg Properties LLC · Casa Grande, AZN6241ERuijne Leo L · Plainview, TXN6241RHayhurst Shane R · Winfield, PAN6241TArm 4 Aviation LLC · Blanchard, IAN6242EDenson Randy A · Meridian, IDN6242GSpencer Aviation Inc · Delaware, OHN6242THuff Glenn R · Garrison, MNN6243GRed Oak Commuter LLC · Red Oak, IAN6243SBlackwood Heath · Meridian, IDN6243TStanek Michael K · Palm Bay, FLN6244ESpicer Aaron D · Wadena, MNN6244RWright Skye R · Quitman, ARN6244TAljanabi Mohammed K · Herndon, VAN6245GCulpepper Christopher H · Harper, TXN6245HBiddle Jeffrey E · New Palestine, INN6245THauck Scott T · Elkhart, INN6246GSchlotte Benjamin R · River Falls, WIN6246KRussell Dustin D · Carthage, TXN6246RLovelace Nicolas J · Panama City, FLN62472Ollmann Matthew P · Poplar Grove, ILN6247EBudenbender Heidi B · Weatherford, TXN6247GBurr Craig R · Tampa, FLN6248TPierce Donald Ray · Phoenix, AZN6249ERlp Aviation LLC · Missoula, MTN6249GMiller Aircraft Services Inc · Crookston, MNN6249RChambers Steve · Elk City, OKN6249SPurawic Jessica · Asheville, NCN624JACobb Jason L · Lancaster, OHN624RWWiles William Anthony · Elkin, NC
Back to AD 94-05-05 R1